Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SFTP issue while downloading logs from db

Author  Topic 

kwikwisi
Constraint Violating Yak Guru

283 Posts

Posted - 2014-10-28 : 15:47:44
Sorry to ask SFTP question here as I couldn't find other forum as active as this and my issue is little urgent.

Hope someone can help me.
I'm downloading SSIS log files from sftp and prepared sftp automation script. Problem is, it keeps prompting for password although I'm using keys. Below is my script, can guide which command to use to kill the password prompt ??

sftp2 -k "C:\Keys\privatekey.apk" -B "E:\SFTPScript\DOWNLOAD_SCRIPT.txt" username@IPAddress

Tks.
   

- Advertisement -