SQL Agent SSIS package fails when not logged in to the serve

Hello,

I have an SSIS package to transfer a file, and the package runs fine when run locally on my development machine. When I deploy it to SQL Server to run as a scheduled job (SQL Agent, under a proxy that has all the permissions), the job runs successfully only when I am logged into the SQL server under the proxy credential. If I log off of it, the job fails with the famous error " In Executing "C:\Program Files (x86)\WinSCP\WinSCP.com" "" at "", The process exit code was "1" while the expected was "0" "

Can anyone please point me in the right direction what is missing here.

Thanks

Please attach a full log file showing the problem (using the latest version of WinSCP).

Hi Martin,

Attached is the log, I tried to remove some sensitive info.

Appreciate your help in this.

Paul

The log file has one part where it was successful (when the user is logged in to server), the other portion (where it ends with "Looking up host..") is when the user is not logged in.

Thanks again.

When running while user is not logged in, WinSCP seems not to have an access to its configuration. So it interprets the IQFTPS as a host name, because it does know IQFTPS site.

It's generally a bad practice to rely on stored site in scripting.

See also:
https://winscp.net/eng/docs/faq_scheduler