What would be a recommended choice of SSIS component to perform SFTP or FTPS task?

Question

Sometimes normal FTP doesn't quite cut it... When you need to do secure FTP via SSIS packages, which 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....

Solution 1

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

Solution 2

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

Solution 3

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

Solution 4

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

Solution 5

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.

View more solutions

Comments

[Kevin Fairchild]

I'm leaning towards this one. Hadn't heard of it before, but it looks like they have plenty of code samples and examples. It's not strictly for SSIS, but that's actually a selling-point for one of the other developers, since it could be used in other apps as well.

[Kevin Fairchild]

I'm looking into this as well, but so far I haven't run across anyone who has actually used it.

[D.S.]

This worked great in the regular IDE. When I tried it in SSIS Script Task, I was unable to add it as a reference?! Any ideas?

[Martin Vobr]

D Scott: adding it as a reference is described at blog.rebex.net/news/archive/2008/10/03/…

[Registered User]

I used a beta version of the 1.2 library in SQL Server 2005 and it worked well enough. I didn't like that you had to create the task first before creating the connection to the FTP server, but it worked well after that point.

[Merritt]

I dont think this is free.

[SuperPoney]

This is not free for sure