SFTP with sql server 2008

Question

I want to know the syntax of SFTP command that will execute by sql server job and what steps will I have to follow to do public key authentication ? I am using SFTP to transfer files from window server 2008 to another window server 2008.

---

Nitin Varshneya

Answer 1

AFAIK sql server doesn't process SFTP. you could try SSIS but that would only give you FTP (if you look in codeplex you will find custom components that should do it).

The main option that you have is to call/execute an external application like WinSCP either via enabling xp_cmdshell and scripting it or using powershell to call it with the correct command line arguments.

Regards

Rui

Answer 2

See these
http://www.example-code.com/sql/sftp.asp
http://www.example-code.com/sql/sftp_pubkeyAuthenication.asp

---

Many Thanks & Best Regards, Hua Min