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.