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.