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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)