Post a reply :: Support Forum

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

Tip: Styles can be applied quickly to selected text.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: File gets transferred when executing command file directly but not remote login

As per https://winscp.net/eng/docs/faq_scheduler:
The local account that runs the SQL server service probably does not have a network access.
bamMorris

File gets transferred when executing command file directly but not remote login

Version of WINCP:5.9
Windows: Windows server 2012 R2
transfer Protocol: SFTP
Scripts: ftp.cmd
open sftp://login:password@website/ -hostkey="ssh-rsa 1024 xx:xx:db"
put \\PPP\PosData\Bofa_00193.txt /incoming/arp/ -nopreservetime -nopermissions
exit
Batch File:
\\PPP\\WinSCP\WinSCP.exe /log=\\PPP\PosData\WinSCP.log /ini=nul /script=\\PPP\PosData\ftpcmd.txt

If I login as the remote user (for example XXX\myuser) and execute the batch file the file transfers. When the batch file gets executed from SQL Server using xp_cmdshell it executes it using the same login but the file does not transfer.