Sad story of SSIS FTP
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 | |
| Download Advanced ETL Processor Enterprise now and transform all your data today! |
We have 169 guests and no members online