DTS Dynamic Filenames
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.
 |
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.
I will let you know that you may have to play with the wildcard characters to get it to pick up the proper file.
for instance if you have a file on the server named “update0125.zip“, you may have problems using “update<mmdd>.zip”.
not sure if its a flaw in their object, but i found that if you use wildcards you'll be fine. for example, for the aforementioned file, I used a File Filter of “*update*<mmdd>.zip” and it worked fine.
|
 |
for date files, if you want to retrieve a file that is dated for yesterday, you would assign a -86400 (seconds) to the File Filter date offset. That will move your <mmddyy> expression back a day. |
>
Click their logo to check out their site for more info...
Written By: host
Date Posted: 1/6/2006
Number of Views: 701
Return