SFTP with sql server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SFTP with sql server 2008

SFTP with sql server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

nitin.varshneya

Posted Wednesday, February 13, 2013 3:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 04, 2013 10:36 PM
Points: 4, Visits: 6

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.

Post #1419371

brad.blackburn

Posted Wednesday, February 13, 2013 10:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:19 PM
Points: 5, Visits: 51

There may be a way but I am not aware of one. I have done an FTP job inside of an SSIS package, SFTP was not an option with SSIS. I guess you could download WinSCP and write a batch script file to do the SFTP with keys. Then you could setup a SQL Job to call out xp_cmdshell to execute that WinSCP batch file. This is just the first thing that came to my mind. Hope this helps.

nitin.varshneya (2/13/2013)

Post #1419641

nitin.varshneya

Posted Wednesday, February 13, 2013 8:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 04, 2013 10:36 PM
Points: 4, Visits: 6

Thanks for your information.

I am not able to find syntax to use SFTP with public key authentication .Can anybody help me ?

Post #1419800

schleep

Posted Thursday, February 14, 2013 8:35 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:38 AM
Points: 344, Visits: 601

This might help: psftp has a public key option.

http://the.earth.li/~sgtatham/putty/0.52/htmldoc/Chapter6.html

Post #1420124

« Prev Topic | Next Topic »

Permissions