Scripting works only from Command prompt

Advertisement

AndyG
Joined:
Posts:
2
Location:
Seattle

Scripting works only from Command prompt

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.

Reply with quote

Advertisement

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.

Reply with quote

AndyG

Good Advice

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. :D Thanks!

Reply with quote

Advertisement

You can post new topics in this forum