Topic "Scripting works only from Command prompt"

Author Message
AndyG
[View user's profile]

Joined: 2008-12-08
Posts: 2
Location: Seattle
Would like to automate FTP of file to remote server from Sequel Job but nothing seems to work. I tried calling WinSCP from another executable, calling it from Sequel using xp_cmdshell, and calling it from Sequel using CmdExec. Nothing works except typing the commands at the command prompt. Any help appreciated. Thanks.
Advertisements
Paulus

Guest


I have the same issue. I find that WinSCP stores information in the user profile, however, when I run script, I scheduled the using another local service account. This means certain information like servers to connect to are not found.
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
Please read FAQ. If that does not help, come back.
_________________
Martin Prikryl
AndyG
[View user's profile]

Joined: 2008-12-08
Posts: 2
Location: Seattle
The FAQs identified the problem for me. Logged into Sequel server with same account that SQL Server Agent runs under, created a profile in WinSCP, now it works fine. Very Happy Thanks!
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License