Secure FTP using SSIS

For FTP we have FTP component in SSIS and for Secure FTP (SFTP) we have to use third party components. The third party component I would recommend is “SFTP” from codeflex. You can download the dll from below location and this work for SSIS 2008. It’s very simple to use.

http://ssissftp.codeplex.com/

After downloading the dll please follow below steps

1.       Copy the dll to the below locations

a.       “C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks\” folder for 64bits operation systems

b.      “C:\Program Files\Microsoft SQL Server\100\DTS\Tasks\” for 32bits operation systems

2.       Register the dll to GAC as below

a.       Gacutil can be find at the location “C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin”

Command to register  is “gacutil /uf "path of SSISSFTPTask100’dll" or

b.       Simply copy the dll to the folder "%WindowsDir%\assembly"