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
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