SSIS job exits with code "1"

Advertisement

geninfarun
Joined:
Posts:
14
Location:
USA

SSIS job exits with code "1"

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?

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
27,226
Location:
Prague, Czechia

Re: SSIS job exits with code "1"

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:\*.*"

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

Reply with quote

Advertisement

You can post new topics in this forum