[quoted text, click to view] Stefan Muehlbauer wrote:
> Hello,
> how can i send a file with the FTP Task direct from the SQLserver 2000
>
> R
> Stefan
>
>
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