- martin
Post a reply
Topic review
- mchellum@hotmail.com
Sending with explicit FTP over TLS - Hangs in SQL Job
Hello all,
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.
UniversalFTPScript.txt
open TestUser@83.111.79.50
put M:\OUT\TM0020121024110922_.csv
exit
The stored session 'TestUser@83.111.79.50' 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!
Thanks
Mark
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.
UniversalFTPScript.txt
open TestUser@83.111.79.50
put M:\OUT\TM0020121024110922_.csv
exit
The stored session 'TestUser@83.111.79.50' 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!
Thanks
Mark