April 21, 2003 at 6:17 pm
I have seen this all over but I haven't found my answer.
I need to setup a DTS package to get multiple text files once a day. Each day the files are names whatever20030401.txt (day of file in YYYYMMDD)
Really, I would like to get all files (mget *.txt). Once I get the files, I need to delete them off the ftp server. Is there a way to do this in SQL Server 2k using ActiveX or even the FTP task in DTS?
An simple example would be even better.
Thank you.
April 24, 2003 at 11:18 am
I process a lot of data that belongs to other companies. Much of this data has to first be acquired from various ftp sites.
So, I want to ftp in information and then process it, so I use DTS to do the whole shabang.
I use the built-in Windows FTP program, http://FTP.exe, to ftp in information. I write an FTP script and pass in the full path and name of the script as a parameter ( -s ) to http://FTP.exe. It executes the script.
In many cases, the script isn't static and needs to be rewritten every day. In those cases, I create an ActiveX script task in DTS that uses the FileSystemObject to write the script to the server every time it runs.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply