dbTalk Databases Forums  

Secure FTP in DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Secure FTP in DTS in the microsoft.public.sqlserver.dts forum.



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

Default Secure FTP in DTS - 09-06-2004 , 11:36 AM






Hi
Is there any way of downloading/uploading files from secure ftp site
using DTS FTP task? If not Can i use windows command line FTP as part
of DTS execute process to do the same? Is there any alternative?

Thanks!

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

Default Re: Secure FTP in DTS - 09-07-2004 , 08:50 PM






The FTP task supports FTP gets (download) but not FTP puts
(upload). You can use the command line ftp. You can execute
this with Execute Process task. It's sometimes easier to use
an FTP script file for the ftp commands and execute ftp
using this script file. To use a file, the command is:
ftp -sC:\PathToYour\FTPFile
In the file, you would just enter your commands...a basic
template being something like the following:
open <ftp site>
<login>
<password>
put <path to file you want to send>
bye

-Sue

On 6 Sep 2004 09:36:18 -0700, dtsguy1 (AT) rediffmail (DOT) com
(Karthik R) wrote:

Quote:
Hi
Is there any way of downloading/uploading files from secure ftp site
using DTS FTP task? If not Can i use windows command line FTP as part
of DTS execute process to do the same? Is there any alternative?

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.