Automation problem with SQL Agent.
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.
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.