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

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.

Hi Martin,

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

Appreciate your help in this.

Paul

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

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