all groups > sql server dts > september 2004 >
You're in the

sql server dts

group:

FTP Task


FTP Task ReportFAQGuy
9/28/2004 7:29:05 AM
sql server dts:
Hi
I DTS, in an FTP task can you access a secure ftp server....if so how do you
do it....
eg I have a site like xx.xx.xx.xx on port xxxx with a specific username and
password.
How do you specify the port. I tried ftp://xx.xx.xx.xx:xxxx but it didn't
work.
Even ftps://xx.xx.xx.xx:xxxx didn't work. It kept on saying cannot connect
to the internet site.
Any help would be appreciated.
Thanks
Re: FTP Task Sue Hoegemeier
9/28/2004 8:07:41 PM
One option is to use an Execute Process task and use the
command line FTP. 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. You can
specify an FTP port with the FTP open command:
open <ftp site port>
<login>
<password>
etc......
bye

-Sue

On Tue, 28 Sep 2004 07:29:05 -0700, ReportFAQGuy
[quoted text, click to view]
Re: FTP Task ReportFAQGuy
9/29/2004 8:25:01 AM
Hi Sue,
thanks for the reply. Ya i know we can do it through an FTP script(written
directly in the ExecuteProcess task or called thorugh a file again in an
executeProcess Task). The point is that i have connected to an FTP site
before throuygh an FTP task. It worked but for some reason for this
particular site the FTP task is not working. Could it be because the site is
a secure FTP site.

Thanks
ReportFAQGuy


[quoted text, click to view]
Re: FTP Task Sue Hoegemeier
9/29/2004 10:39:57 AM
It's likely due to needing to use a non-default port. The FTP task
supports basic types of FTP commands but will use default FTP settings
for transfer mode, port, etc. If you are using FTP and any non-default
settings, you need to use the command line FTP.

-Sue

On Wed, 29 Sep 2004 08:25:01 -0700, ReportFAQGuy
[quoted text, click to view]
Re: FTP Task Peter A. Schott
10/1/2004 12:50:28 PM
I think you can look into the FTP task @ www.sqldts.com as well. I seem to
remember that it can use non-standard ports. However, if you're trying to use
SFTP or FTPS, you may be limited to using your 3rd party util to run that.

-Pete

[quoted text, click to view]
AddThis Social Bookmark Button