DOS is very useful. I have an application that uses SQL2000. I often create CSV files in DTS to FTP to Hosted applications.

I use a BAT file to run an FTP script and also to datestamp an archived version. The date is using the date string, so the date format on the server is critical and the offsets might be different.

http://FTP.BAT

set today=%DATE%

set mm=%today:~0,2%

set dd=%today:~3,2%

set yyyy=%today:~6,4%

set ts=%yyyy%%mm%%dd%

ftp -s:ftpput.ftp > ftpput_%ts%.log

copy /B /Y \\Srvr\dir\Dir\My.csv \\Srvr\dir\Dir\Archive\%ts%_My.csv

FTPPUT.FTP

open http://ftp.Hosted.com

username

password

cd xyz

lcd \Dir\Dir

binary

put My.csv

bye

It is easy and the FTP itself is also piped to a log.