Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

geninfarun

thank you, that worked nicely.
martin

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.
geninfarun

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?