6

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

Kevin Fairchild
  • 10,891
  • 6
  • 33
  • 52
  • 1
    Buy Taskfactory for $1,450 and ignore everything else in this thread, get 21 other insane features for SSIS, and win. You do not need a component for FTPS in SSIS as that is part of the .NET framework and available inside an FTP task in SSIS. http://pragmaticworks.com/Products/Task-Factory – Bryan Jan 09 '16 at 14:20

6 Answers6

4

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

Martin Prikryl
  • 49
  • 1
3

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

Kilhoffer
  • 32,375
  • 22
  • 97
  • 124
2

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

Kevin Fairchild
  • 10,891
  • 6
  • 33
  • 52
  • 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. – Registered User Jan 04 '09 at 17:23
2

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

Mike Dimmick
  • 9,662
  • 2
  • 23
  • 48
  • 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 Sep 30 '08 at 13:39
  • 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? – D.S. Sep 30 '08 at 20:05
  • 1
    We ended up going to with Rebex after trying both it and Secure Blackbox. Rebex seemed the best for our needs. – Kevin Fairchild Oct 02 '08 at 17:34
  • D Scott: adding it as a reference is described at http://blog.rebex.net/news/archive/2008/10/03/how-to-register-sftp-and-ftp-ssl-for-use-in-ssis-package.aspx – Martin Vobr Nov 12 '08 at 01:47
  • I dont think this is free. – Merritt Apr 03 '14 at 19:48
  • This is not free for sure – SuperPoney Nov 20 '20 at 09:39
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

1

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.

Martin Vobr
  • 5,757
  • 2
  • 37
  • 43