Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1905

Re: SFTP in MSSQL

Show all headers | View raw

Wonder if you could echo yes and pipe it into the command?

ECHO yes | psftp -P 23 192.168.1.251 -l myUserRed -pw mypasswordRed -b E:\Data\Test\Test2\ftp_commands\ftpScriptThatTransfersfiles.txt

On Wednesday, May 5, 2010 at 2:52:52 PM UTC-4, dennis wrote:
> Yes I did get this resolved. It is kind of an ugly work around. The error is because you are getting prompted the first time you run SFTP from that MSSQL account, so you have to force in a "y" response.
> 
> To do this I created a text file named "yes.txt" and inside of it i typed the word "yes".
> 
> Then in my batch script i reference it to answer the prompt like so:
> 
> 
> psftp -P 23 192.168.1.251 -l myUserRed -pw mypasswordRed -b E:\Data\Test\Test2\ftp_commands\ftpScriptThatTransfersfiles.txt < E:\Data\Test\Test2\BCP\yes.txt
> 
> exit
> 
> 
> 
> 
> Alex Torres wrote:
> 
> Resolved?
> 05-May-10
> 
> Did you ever get this resolved?  I am having the same issue trying to post files to an SSH FTP server using psftp and XP_CMDSHELL.
> 
> Previous Posts In This Thread:
> 
> 
> Submitted via EggHeadCafe - Software Developer Portal of Choice 
> BOOK REVIEW: Effective C#, Second Edition [Addison Wesley]
> http://www.eggheadcafe.com/tutorials/aspnet/b2f8766d-a4c1-4d5a-97af-c38852b3b455/book-review-effective-c.aspx

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

Re: SFTP in MSSQL pjmahoneyit@gmail.com - 2015-04-09 19:57 -0700

csiph-web