THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Third-Party Components: CozyRoc

This blog has moved! You can find this content at the following new location:

Published Tuesday, December 18, 2007 6:46 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Denis Gobo said:

The way I use to do the sFTP thing in DTS is this

Grab Putty.exe put it on the server

Create a BAT and a SRC file

In the BAT file you would have the IP and login info and a call to the SRC file

In the SRC file you would have CD, GET, PUT, etc etc

The SRC file would be created from within DTS everyday with the new filename and voila. Very simple actually

December 18, 2007 1:31 PM

Steve Hogg said:

PSFTP works great in DTS but not in SSIS. A third party control like CozyRoc or /n Software is probably the way to go. I am investigating both options and leaning towards CozyRoc based on cost and compatibility with my objectives.

For a list of why PSFTP does not work with SSIS and SQL Server Agent, go here.

September 12, 2008 8:26 AM

andyleonard said:

Thanks for the link to that discussion Steve!

:{> Andy

September 12, 2008 11:37 AM

Leemor said:

I got around this by creating a windows scheduled task that launches the .BAT file that runs psftp and the scr file. Then from SSIS I ran the scheduled task: C:\WINDOWS\system32\schtasks.exe /RUN /TN "ScheduledTaskName"

November 17, 2009 3:31 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement