Recommend ONE favorite SSIS component that does SFTP/FTPS

Question

Sometimes normal FTP doesn't quite cut it... When you need to do secure FTP via SSIS packages, what ONE product would you recommend?

Before answering, please see if someone has already suggested the same thing and, if so, vote it up.

NOTE: Ideally, it needs to handle both SSH and SSL FTP connections, but I'd consider two separate components if it makes the most sense....

Answer 1

A coworker pointed out CozyRoc, but I haven't tried it out yet.

Answer 2

I use Rebex.net File Transfer Pack for SFTP and FTP transfers in .NET.

Answer 3

Secure Blackbox does SSH and is supposed to be good, but no personal experience.

Answer 4

Hi, our Rebex File Transfer Pack includes both SFTP and FTP/SSL.

I wrote a blogpost about registering the component for use in SSIS package: http://blog.rebex.net/news/archive/2008/10/03/how-to-register-sftp-and-ftp-ssl-for-use-in-ssis-package.aspx.

Answer 5

Check SFTP connection and task for SSIS in SecureBlackbox for Business Servers. FTP/FTPS task is also included into SecureBlackbox for Business Servers.

Answer 6

Not actually SSIS component. But you may consider checking guide how to use WinSCP open source SFTP client as task in SSIS.

Answer 7

Have you tried SSIS Task Factory from Pragmatic Works.... Community Edition is FREE

SSIS Custom Tasks and Components

including SFTP Task (Secure FTP ... FTPS) Compression/Zip Task Upsert Destination (Bulk Update or Insert)

and many more....

They have some really kool components

Answer 8

edtFTPnet/PRO can also be used for SSIS, and supports FTP, FTPS and SFTP.