SQL Server Performance Forum – Threads Archive
FTP to a remote machine
Hi all, I need to FTP some text files (on a local machine)to a remote machine.How and what I can do using DTS packages?? Any suggestions!! Thanks
Ratna
quote:Originally posted by mickey
Hi all,
I need to FTP some text files (on a local machine)to a remote machine.
How and what I can do using DTS packages?? Any suggestions!! Thanks
Ratna
How and what I can do using DTS packages?? Any suggestions!! Thanks
Ratna
You can run an external command and do the FTP with it. The command line would look like:
FTP -sDathScriptFile.ftp …of course you change dath to your path. Example contents of ScriptFile.ftp open superserver
username
password
binary
cd ushare
lcd F:SuperServerDataFiles
put SuperTextFile.txt
quit Now if you are looking to run a FTP on a list of file names that would change, you could "Generate" the script for the FTP using ActiveX Scripting and the FileSystemObjects. I can load an example of this also. Hope this helps.
There is an article on sqlteam.com:
http://www.sqlteam.com/item.asp?ItemID=12408
]]>