The FTP task in DTS supports FTP gets but not FTP puts. You
can use the command line ftp. You can execute this with
Execute Process task. You can use an ActiveX script task and
FileSystemObject to generate an FTP script file for the ftp
commands if you need this to be built dynamically. Then
execute ftp using the script file. To use a file, the
command is:
ftp -sC:\PathToYour\FTPFile
In the file, you would just enter the following:
open <ftp site>
<login>
<password>
put <path to file you want to send>
bye
-Sue
On Wed, 9 Jun 2004 12:45:22 -0700, "Gary"
<gary.conte (AT) am (DOT) sony.com> wrote:
Quote:
I need to automate multiple FTP puts.
Can this be done via DTS and if so, how?
Thanks. |