Topic "Sending with explicit FTP over TLS - Hangs in SQL Job"

Author Message
mchellum@hotmail.com
[View user's profile]

Joined: 2012-10-25
Posts: 1
Location: London
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
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
Please read FAQ:
https://winscp.net/eng/docs/faq_scheduler

If that does not help, come back.
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License