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

Re: SFTP in MSSQL

X-Received	by 10.68.216.225 with SMTP id ot1mr39891514pbc.1.1428634648936; Thu, 09 Apr 2015 19:57:28 -0700 (PDT)
X-Received	by 10.182.230.198 with SMTP id ta6mr268275obc.24.1428634648881; Thu, 09 Apr 2015 19:57:28 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!l13no3269576iga.0!news-out.google.com!n7ni3452igk.0!nntp.google.com!m20no2261531iga.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Thu, 9 Apr 2015 19:57:28 -0700 (PDT)
In-Reply-To	<201055145250dennben78@yahoo.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=68.57.204.104; posting-account=UPf9qgoAAAAtVif9r89XTpqmVHRhfWy8
NNTP-Posting-Host	68.57.204.104
References	<201055141039atorres@oris-corp.com> <201055145250dennben78@yahoo.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<ccab6254-eb26-4925-ad14-8fe935ec0254@googlegroups.com> (permalink)
Subject	Re: SFTP in MSSQL
From	pjmahoneyit@gmail.com
Injection-Date	Fri, 10 Apr 2015 02:57:28 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1905

Show key headers only | 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