Process exit code 1 in SSIS after enabling logging
Hi,
We're using WinSCP in SSIS to upload files to SFTP server with a script. We've had a few problems, so tried to enable logging, but this seems to trigger a different exit code which SSIS doesn't like.
Logs are populated and some files copied over.
To enable logging we add to the Execute Process Task attributes:
SSIS returns this:
Is this a standard exit code when logging is enabled, or is there another problem somewhere?
We're using WinSCP in SSIS to upload files to SFTP server with a script. We've had a few problems, so tried to enable logging, but this seems to trigger a different exit code which SSIS doesn't like.
Logs are populated and some files copied over.
To enable logging we add to the Execute Process Task attributes:
+ "/loglevel=0" + "/log=E:\SSIS Projects\Folder1\WINSCP_log.txt"
SSIS returns this:
Description: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.com" ""/script=E:\SSIS Projects\folder1\SFTPconnect -folder sync.txt"+"/loglevel=0"+"/log=E:\SSIS Projects\folder1\Winscp_log.txt"" at "", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1).
Is this a standard exit code when logging is enabled, or is there another problem somewhere?