THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Andy Leonard

SSIS and ETL
Thoughts about Database and Software Development, and the tools of the trade.

SSIS Third-Party Components: CozyRoc

CozyRoc has a suite of Control Flow Tasks that are worth a look. We're using the SFTP (Secure FTP) and SSH Connection Manager on my current project.

Once we identified the need for SFTP, I looked around and identified a couple companies / products. The CozyRoc download was the only one I could make work.

I've communicated with the company a few times with questions about functionality. I found Ivan to be very responsive and refreshingly open.

We're planning to use other tasks in the suite as well: the Script Task Plus, Zip Task, and Database Partitions Task are slated for use. It's all good stuff and the price is extremely reasonable ($99.95!) - especially when compared to the competition.

Kudos Ivan.

:{> Andy

 


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

Comments

 

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. http://www.sqlservercentral.com/Forums/Topic366150-148-2.aspx

September 12, 2008 8:26 AM
 

andyleonard said:

Thanks for the link to that discussion Steve!

:{> Andy

September 12, 2008 11:37 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About andyleonard

Andy Leonard is a SQL Server MVP, database developer, engineer, husband, and father. Andy lives in Farmville Virginia with his lovely bride Christy Lynn and their three children: Stevie Ray, Emma Grace, and Riley Cooper. Andy's two older children - Manda and Penny - are grown and married. When he's not working (and Andy works a lot), he enjoys spending time with his family, working on their old farmhouse, fishing, and reading older sci-fi series.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement