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

Author Message
[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.

open TestUser@
put M:\OUT\TM0020121024110922_.csv

The stored session 'TestUser@' is sending with FTP explicit encryption and
I am running it from an 'Execute Process Task' in SSIS that calls a .bat file containing: /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!
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 26889
Location: Prague, Czechia
Please read FAQ:

If that does not help, come back.
Martin Prikryl

You can post new topics in this forum


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!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License