SQL Server Performance

Secure FTP

Discussion in 'Analysis Services/Data Warehousing' started by lshores, Dec 19, 2003.

  1. lshores New Member

    Does anyone know if sftp is supported by MS SQL 2000? I currently use the xp_cmdshell to call the ftp protocol to transfer files from a directory outside of our network to a local directory.
  2. BigJimSlade New Member

    you could either wrap it up in a script .bat or create a custome DTS task.
    There is no support in the DTS file transfer task for the sftp or scp protocols you can only use FTP or SMB

Share This Page