|
Home > Archive > MS SQL Server DTS > January 2006 > Task FTP SQLServer 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Task FTP SQLServer 2000
|
|
| Stefan Muehlbauer 2006-01-28, 7:23 am |
| Hello,
how can i send a file with the FTP Task direct from the SQLserver 2000
R
Stefan
| |
| Darren Green 2006-01-28, 7:24 am |
| 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
http://www.sqlis.com
| |
|
|
|
|
|