Can SSIS do SFTP? and how?

0 votes
asked Aug 3, 2012 by Rebex KB (8,330 points)
edited Aug 3, 2012

I want to know whether SSIS can do SFTP. If yes, how does it work?

Applies to: Rebex SFTP

1 Answer

0 votes
answered Aug 3, 2012 by Martin Vobr (12,940 points)
edited Aug 3, 2012

SSIS does not support a SFTP transfer out of the box. You would need a third party component. You can easily use a Rebex SFTP .NET library with a SSIS script task.

  1. Register Rebex SFTP for use in SSIS (as described in "HOWTO: Registering SFTP and FTP/SSL for use in SSIS package")
  2. Add new Script Task
  3. Modify the script via the "Desing script" in "Properties dialog". The Visual Studio for Applications IDE pops up.
  4. Add reference to the DLLs in the Project Explorer window.
  5. Add the code to connect, transfer files or do whatever you want as described in SFTP tutorial.
...