how to ftp a file in DTS

[snowingnow]

I would like to ftp a file to another saver WITH DTS, how can i do it? Thanks

 

[mrdenny]

DTS can not send a file nativly. You can setup a batch file with uses the automation capabilities of the ftp.exe command line ftp program and then call the batch file from the DTS package. You'll have to google for how to automate a command line ftp transfer.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog