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 practically 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

 

SSIS FTP

AETL FTP

AETL FTP4

AETL FTP2

AETL FTP3

 

Download Free Trial Learn More About Our ETL Software

We have 178 guests and no members online