dbTalk Databases Forums  

FTP via DTS

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss FTP via DTS in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gary
 
Posts: n/a

Default FTP via DTS - 06-09-2004 , 02:45 PM






I need to automate multiple FTP puts.

Can this be done via DTS and if so, how?

Thanks.

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: FTP via DTS - 06-09-2004 , 09:48 PM






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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.