Problem with WinSCP and SQL Server 2005 Job Agent
I have created an SSIS package that uses a WinSCP script file to download files from a SFTP site. When I run the SSIS package manually from the SSIS Server it works great. However when I set up a job in SQL Server Agent to execute the package, it only hangs up and does not run or error out. Has anyone experienced this before and is there a work around?
Regards
Regards