Wednesday, March 7, 2012

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

No comments:

Post a Comment