August 1, 2002 at 9:27 am
After creating a text file with DTS in SQL Server 7.0, I'd like to automatically have that text file FTPed (uploaded) to another server at a certain time once a day. Anyone know of a good FTP client that can do this?
Thanks
August 2, 2002 at 1:28 am
Why bother with obtaining an ftp client, when you can simply utilise the ftp command from the command line. This way you can add it in as a seperate task to your DTS package which occurs once you finish creating your file.
I can't remember the syntax to automatically login to an ftp site, but it was something like:
"ftp <hostname> -u<username> -p<password>"
August 2, 2002 at 6:15 am
One thing you also might look at doing with the command line version is building a script file. You can pass the script file to the FTP command and it'll automatically carry out the commands listed within.
It's also not too hard to generate a script file on the fly and then pass it to the FTP command. We do that in one case where I work.
K. Brian Kelley
http://qa.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
August 2, 2002 at 7:34 am
HI,
the syntax is :
http://FTP.EXE -A -s:e:\a.txt http://ftp.nai.com
where a.txt is:
cd /virusdefs/4.x
prompt
lcd c:mget sdat*.exe sdat*.exe
quit
Bye
Antonio
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply