I have the following script, which uploads files successfully via a .bat file called from an 'Execute Process Task' in a Visual Studio SSIS package, but as soon as I try to run it through a SQL Job it just sits there running forever and I eventually have to cancel it.
The stored session 'TestUser@18.104.22.168' is sending with FTP explicit encryption and
I am running it from an 'Execute Process Task' in SSIS that calls a .bat file containing:
winscp.com /script=C:\test\FTPScript.txt /log=C:\test\log.txt
I am also running it in VS as the same user I an trying to run it under in SQL Management Studio.
Any help will be extremely welcome!