DTS - FTP Task - SQL Server 2000

Hi
Could any body tell How to download files from Internet where Source file server is using SFTP (Secure FTP)?
Note: I am able to configure and download files from Internet where Source file server is configured for FTP using FTP task in DTS Package.
Thanksone option is to download a client for SFTP, create a CMD files with commands and execute under xp_cmdshell

i.e. look at PSFTP

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

simas|||Thank you for your valuable reply...Please inform me if any come across any alternatives...Thaks

DTS

How do we configure DTS package to transfer more than 1 table data transfer from a Source to Destination Server?
I have about 100 odd tables in Source & need to do data transfer for all within 1 go. Is this possible?If you are on SQL Server 2000 and the source and destination
are both SQL Server(7 or above), you can use the Copy SQL
Server Objects task.
-Sue
On Wed, 5 Nov 2003 13:11:07 -0800, "Prasanna"
<anonymous@.discussions.microsoft.com> wrote:
>How do we configure DTS package to transfer more than 1 table data transfer from a Source to Destination Server?
>I have about 100 odd tables in Source & need to do data transfer for all within 1 go. Is this possible?|||The simplest way is USe the DTS wizard.
or
In , SQLEM,go to "Tools" and then CLick "DTS" and then Use
the Export/Import. (This will also get you the DTS Wizard)
Very simple and user friendly wizard.You can easily do it.
SQLVarad(MCDBA-1999,MCSE-1999)
>--Original Message--
>If you are on SQL Server 2000 and the source and
destination
>are both SQL Server(7 or above), you can use the Copy SQL
>Server Objects task.
>-Sue
>On Wed, 5 Nov 2003 13:11:07 -0800, "Prasanna"
><anonymous@.discussions.microsoft.com> wrote:
>>How do we configure DTS package to transfer more than 1
table data transfer from a Source to Destination Server?
>>I have about 100 odd tables in Source & need to do data
transfer for all within 1 go. Is this possible?
>.
>