Wednesday, February 13, 2013 10:33 AMI 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.
Wednesday, February 13, 2013 12:54 PM
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.
- Marked As Answer by Iric WenModerator Thursday, February 21, 2013 9:33 AM
Wednesday, February 13, 2013 1:17 PMSee these
Many Thanks & Best Regards, Hua Min