What would be a recommended choice of SSIS compone

Question

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 5 years ago.

Improve this 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....

Answer 1

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 2

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 3

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

Answer 4

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

Answer 5

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

Answer 6

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