According to Wikipedia "FTP was not designed to be a secure protocol, and has many security weaknesses" and yet it the only protocol supported by SSIS. This fact alone makes this SSIS component practicaly useless

FeatureSSISAdvanced ETL Processor Ent/Visual Importer ETl Ent
  FTP - File Transfer Protocol Supported Supported
  FTPS - FTP over implicit TLS/SSL Not Supported  Supported
  FTPES - FTP over Explicit TLS/SSL Require TLS Not Supported Supported
  FTPES - FTP over Explicit TLS/SSL Not Supported Supported
  SFTP - SSH File Transfer Protocol Not Supported Supported
  FTP - Port ranges Not Supported Supported
  Downloads Supported for FTP protocol only Supported
  Uploads Supported for FTP protocol only Supported
  Create Remote Directory Supported for FTP protocol only Supported
  Delete Remote Directory Supported for FTP protocol only Supported
  Delete Files Supported for FTP protocol only Supported
  Rename File >Not Supported Supported
  Directory List Not Supported Supported
  Move Files Not Supported Supported

gg

SSIS FTP

AETL FTP

AETL FTP4

AETL FTP2

AETL FTP3

 

More about SFTP support

More about FTP Support

Etl-tools.com announces partnership with Slemma

slemma

https://slemma.com/

About Slemma

Slemma is a simple business intelligence software that helps modern businesses leverage data into advantages online with less effort. Plug in directly to the most popular databases and cloud services; create, customize, and share dashboards and visualizations with the entire team.

Working with Slemma

loading data into slemma

All our ETL products support now loading data into slemma
Connecting to Slemma Wiki Page

Based on the customer feedback in the latest version of Advanced ETL Processor we have introduced support for JSON

What is JSON

JSON is short for JavaScript Object Notation. It is a way to store information in an organized, easy-to-access manner. In a nutshell, it gives us a human-readable collection of data that we can access in a really logical manner.

Benefits of using JSON

JSON is much more efficient than XML. It reqires less network traffic processing power and memory to work with  

More Information

  1. JSON only has three simple types – strings, numbers and Booleans – and two complex types – arrays and objects.
  2. A string is a sequence of zero or more characters wrapped in quotes with backslash escapement, the same notation used in most programming languages.
  3. A number can be represented as integer, real, or floating point. JSON does not support octal or hex. It does not have values for NaN or Infinity. Numbers are not quoted.
  4. A JSON object is an unordered collection of key/value pairs. The keys are strings and the values are any of the JSON types. A colon separates the keys from the values, and comma separates the pairs. The whole thing is wrapped in curly braces.
  5. The JSON array is an ordered collection of values separated by commas and enclosed in square brackets.
  6. The character encoding of JSON text is always Unicode. UTF-8 is the only encoding that makes sense on the wire, but UTF-16 and UTF-32 are also permitted.
  7. JSON has no version number. No revisions to the JSON grammar are anticipated.
  8. JSON has become the X in Ajax. It is now the preferred data format for Ajax applications. The most common way to use JSON is with XMLHttpRequest. Once a response text is obtained, it can quickly be converted into a JavaScript data structure and consumed by a program
  9. JSON's syntax is significantly simpler than XML, so parsing is more efficient.
  10. JSON doesn't have namespaces. Every object is a namespace: its set of keys is independent of all other objects, even exclusive of nesting. JSON uses context to avoid ambiguity, just as programming languages do.
  11. JSON has no validator. Being well-formed and valid is not the same as being correct and relevant. Ultimately, every application is responsible for validating its inputs.JSON Examples

JSON array

{
"Drinks": ["Water", "Beer", "Vine"]
}

JSON Objects

{ 
  "Patient": {
    "ID": 1,
    "Name": "Batman"
    "Age": 23,
    "friends": ["SpiderMan","IronMan"],
    "complaint": "Blured night vision"
   }
}

Advanced ETL Processor JSON Transformations

json transformation functions

Example

json transformation example

Visit JSON Wiki Page

Quite often people ask us how to stop all ETL packages execution.

“When I stat Advanced ETL Processor it immediately runs transformation package. How can I avoid it?”

Most of the time, this is because Professional version is being used to execute the packages.

Better option is to use Enterprise version agent and run tasks in parallel.

To stop execution

  1. close Advanced ETL Processor/Visual Importer ETL
  2. click  Start => DB Software Laboratory => Advanced ETL Processor Enterprise=> Advanced ETL Processor Enterprise Options=>Execution
  3. and check ‘Do not execute any actions’

Options

This work for both Advanced ETL Processor and Visual Importer ETL

Related forum posts:

 

Customer Loyalty Programs

 

A Free License for IT Professionals

Send us a link to your profile and get a free license for any ETL product!

suit up
Promote our ETL Software

You can get a significant discount, and even a free license, by spreading a word about our ETL Software.

chat
Competitive Upgrades

Get 50% OFF for switching to our ETL Software from competing tools!

money

Go to top