Topic "SSIS job exits with code "1""

Author Message
geninfarun
[View user's profile]

Joined: 2009-11-17
Posts: 14
Location: USA
I have setup a simple execute process task to copy a file from a remote sftp to the local drive. In the Program Executeable I set to
C:\Program Files (x86)\WinSCP\WinSCP.exe

and under command options I set to
savedsessionname option confirm off /command "get /files/*.* c:\*.*"

The scheduled job I created in SQL Agent works fine if I keep winscp running in the background. But if winscp is not running, it returns error code "1" instead of 0 and terminates. What am I doing wrong here?
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24530
Location: Prague, Czechia
Quote:
and under command options I set to
savedsessionname option confirm off /command "get /files/*.* c:\*.*"

Should be:
/command "open savedsessionname" "option confirm off" "get /files/*.* c:\*.*"

Quote:
The scheduled job I created in SQL Agent works fine if I keep winscp running in the background. But if winscp is not running, it returns error code "1" instead of 0 and terminates. What am I doing wrong here?

This does not make any sense to me.
_________________
Martin Prikryl
geninfarun
[View user's profile]

Joined: 2009-11-17
Posts: 14
Location: USA
thank you, that worked nicely.
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