Patrick-

Put these or equiv in a whatever.ftp file.
AT DOS type "ftp" then type help for options...

open remotehost
username
password
hash
Binary
cd /xyz/xyz/xyz
Dir
put C:\junk\Common\Out\filename
put P:\junk\Common\Out\filename
Dir
Disconnect
Bye

Then to do the transfer:

ftp -s:"whatever.ftp"

That will do it.

Chris


-----Original Message-----
From: Patrick Trongo
[mailto:mssqldba-ezmlmshield-x902898.[Email address protected]
Sent: Friday, April 29, 2005 1:28 PM
To: LazyDBA Discussion
Subject: How hard is it to FTP using DTS?



We want to export a file via FTP anyone have any experience here? HELP!


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


MS Sql Server LazyDBA home page