Groups | Blog | Home
all groups > sql server dts > january 2006 >

sql server dts : Task FTP SQLServer 2000


Stefan Muehlbauer
1/28/2006 12:00:00 AM
Hello,
how can i send a file with the FTP Task direct from the SQLserver 2000

R
Stefan

Darren Green
1/28/2006 12:00:00 AM
[quoted text, click to view]

You cannot use the stock FTP task to upload files, it only supports
download. Some options-

There is a free FTP Task that does support upload on SQLDTS.com. If it
works for you, use it.

Use a third party FTP COM object in an ActiveX Script. There is one on
SQLDTS.com again, a wrapper around the WinInet APIs, or plenty more out
there.

Use ftp.exe via ( a batch file and script file) the Execute Process Task.

--
Darren
http://www.sqldts.com
Nigel Rivett
1/29/2006 3:18:27 PM
see
http://www.nigelrivett.net/FTP/s_ftp_PutFile.html

[quoted text, click to view]
AddThis Social Bookmark Button