Search
January 07, 2009   |  Login  |  
 Archive of Entries Minimize

 Print   
 sql server ftp task Minimize
Location: BlogsThe Woolston Blog    
Posted by: daniel 9/15/2005 4:00 PM
o.k. everything i said about the sql server stock ftp task in my earlier post should be forgotten and uninstalled from your long term memory.  after running one of my ftp scripts for a few days of testing, i've noticed that the ftp object isnt the most reliable control in the world.  the ftp would work sporadically and for a mission critical update process....sporadic isn't language that i'm comfortable in using.

so after some googling research I discovered a third party ftp control for sql server 2000. and it works well. It has a multitude of ftp-related configuration settings as you can see in the various screenshots.  of particular interest to me was the ability to do file filters.  because most of my files are dated zip files, I really needed something that could handle dynamic naming.  the sqldts control allows me to specify a formatted date filename for use in the ftp retrieval. and to top it off...this particular control will allow me to setup multiple file transfers in one object...something that the stock object wouldnt allow me to do with dynamic SourceFilename.  my initial test phase is showing a more stable product.

Click their logo to check out their site for more info...

Permalink |  Trackback

Your name:
Title:
Comment:
Add Comment   Cancel 

  
 Search_Blog Minimize

 Print   
You are here: - Blogs
Copyright 2005 Dan Woolston
www.danwoolston.com
Terms Of Use
Privacy Statement