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 8:00 am
This was removed by the editor as SPAM
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply