Oliphant wrote:

Suggestion : Check the FailTaskIfReturnCodeIsNotSuccessValue property of the Process in SSIS
Just set this to False. This may get you right through.

jimbo20814 wrote:

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
Arguments: /script=D:\Success_Factors\SCP_Script\JimScript.txt

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
open sftp://ecom:XXXX@sftp4.successfactors.com
cd outgoing
get JimTest.txt D:\Success_Factors\From_FTP_Server\
exit

I'm running WinSCP 4.3.5 (build 1463) on Windows 7.

Any ideas?

This worked for me! Thanks a lot.

It's recommended that you isolate the script run from GUI configuration:
https://winscp.net/eng/docs/scripting#configuration

This happened to me too and drove me crazy.

The files that I wanted were in the root directory, meaning that I didn't need (or want) WinSCP to navigate to a new directory, but it was anyway.

By default, WinSCP remembers the last directory used, and if the last directory used was the root directory, it remembers "/" as the directory used. So, the next time you attempt to connect, WinSCP attempts to find the "/" directory, which doesn't exist.

To get around this problem:
> Edit the connection
> Select 'Advanced'
> Select 'Directories' in the Advanced settings
> Deselect ‘Remember last used directory’ and remove the “/” in the Remote directory box.

Pepys wrote:

Have you solved your problem and if yes how? This is really getting on my nerves now... I have tried everythhing and probably not the right solution of course...

Your question on stackoverflow.com:
https://stackoverflow.com/q/21303885/850848

Hey jimbo20814,

Have you solved your problem and if yes how? This is really getting on my nerves now... I have tried everythhing and probably not the right solution of course...

Any help will be much appreciated :)

Regards,
Pepys

Suggestion : Check the FailTaskIfReturnCodeIsNotSuccessValue property of the Process in SSIS
Just set this to False. This may get you right through.

jimbo20814 wrote:

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
Arguments: /script=D:\Success_Factors\SCP_Script\JimScript.txt

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
open sftp://ecom:XXXX@sftp4.successfactors.com
cd outgoing
get JimTest.txt D:\Success_Factors\From_FTP_Server\
exit

I'm running WinSCP 4.3.5 (build 1463) on Windows 7.

Any ideas?

Please read FAQ:
https://winscp.net/eng/docs/faq_scheduler

If that does not help, come back.

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
Arguments: /script=D:\Success_Factors\SCP_Script\JimScript.txt

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
open sftp://ecom:XXXX@sftp4.successfactors.com
cd outgoing
get JimTest.txt D:\Success_Factors\From_FTP_Server\
exit

I'm running WinSCP 4.3.5 (build 1463) on Windows 7.

Any ideas?