Recently I had a need to create a SQL Server 2008 SSIS package that could do SFTP transfers. The FTP component that comes with SSIS is very useful but it cannot do secure transfers. In the past I have had to use scripting to create dynamic script files for WS_FTP pro (which I do use and like very much!!) but this brought in many more moving parts and was subject to failure for a number of reasons. After a bit of searching I found http://www.cozyroc.com and in particular the SFTP component: http://www.cozyroc.com/ssis... ......