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