Suggestion : Check the FailTaskIfReturnCodeIsNotSuccessValue property of the Process in SSIS
Just set this to False. This may get you right through.
Hi, when I execute a WinSCP script from via a winscp.exe command line, it works fine but doing the same via a SSIS (sql server integration services) package returns an error. In the SSIS Execute Process Task Editor I have the below settings:
Executable: C:\Program Files (x86)\WinSCP\WinSCP.exe
Running the package returns the below:
Error: 0xC0029151 at Get files via SFTP, Execute Process Task: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.exe" "/script=D:\Success_Factors\SCP_Script\JimScript.txt" at "C:\Program Files (x86)\WinSCP\", The process exit code was "1" while the expected was "0".
Task failed: Get files via SFTP
The script is the below. I've XXXX the password.
option batch off
option confirm off
get JimTest.txt D:\Success_Factors\From_FTP_Server\
I'm running WinSCP 4.3.5 (build 1463) on Windows 7.
This worked for me! Thanks a lot.