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] <ReportFAQGuy@discussions.microsoft.com> wrote:
>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
>ReportFAQGuy
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] "Sue Hoegemeier" wrote:
> 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
> <ReportFAQGuy@discussions.microsoft.com> wrote:
>
> >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
> >ReportFAQGuy
>
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] <ReportFAQGuy@discussions.microsoft.com> wrote:
>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
>
>
>"Sue Hoegemeier" wrote:
>
>> 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
>> <ReportFAQGuy@discussions.microsoft.com> wrote:
>>
>> >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
>> >ReportFAQGuy
>>
>>
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] Sue Hoegemeier <Sue_H@nomail.please> wrote:
> 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
> <ReportFAQGuy@discussions.microsoft.com> wrote:
>
> >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
> >
> >
> >"Sue Hoegemeier" wrote:
> >
> >> 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
> >> <ReportFAQGuy@discussions.microsoft.com> wrote:
> >>
> >> >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
> >> >ReportFAQGuy
> >>
> >>
Don't see what you're looking for? Try a search.