I've created an SSIS 2008 R2 package with an Execute Process task to upload files to our SFTP server. I've used the example script and Execute Process task outlined on page https://winscp.net/eng/docs/guide_ssis, with the only difference being that I included the user name, password, SFTP address instead of pointing to a Session file. I created a job to run this package, but although it completes the SFTP transfer successfully, the Job fails every time with the following error:
The process exit code was "1" while the expected was "0".
The Execute Process task in my package uses a zero for a Success Value. The Execute Process task is set up exactly like the image in the link above.
I've tried several changes: I've pointed the Execute Process at the COM file instead of the EXE, but I get the same results. I've also tried changing OPTION BATCH ON to OPTION BATCH ABORT, uploading to the main folder (as opposed to one of the SFTP server's child folders), but I get the same Job failure message every time.