Dave Noderer's Blog

South Florida does .NET!

  Home  |   Contact  |   Syndication    |   Login
  201 Posts | 0 Stories | 362 Comments | 28 Trackbacks

News

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

Image Galleries

.NET Community

Life at the Beach

My Blog Friends

December 2009 Entries

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