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
|Feature||SSIS||Advanced 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|
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.
All our ETL products support now loading data into slemma
Based on the customer feedback in the latest version of Advanced ETL Processor we have introduced support for JSON
JSON is much more efficient than XML. It reqires less network traffic processing power and memory to work with
"Drinks": ["Water", "Beer", "Vine"]
"complaint": "Blured night vision"
Quite often people ask us how to stop all ETL packages execution.
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
This work for both Advanced ETL Processor and Visual Importer ETL