Please read FAQ:
My script works fine when executed manually, but fails or hangs when run by Windows Scheduler, SSIS or other automation service. What am I doing wrong?

If that does not help, come back.

Hi all,

I have some problem with WinSCP when I want to use it with SQL Agent.
I have a SSIS package which use WinSCP with an "Execute Process Task" toolbox.
The package runs with success.

When I put my package on my SQL Server File System it still works correctly.
But when I try pour launch my package with SQL Agent (in order to automate the job), the job starts and run without end.