[Execute Process Task] Error xxxxx The process exit code was "1" while the expected was "0".
This error will occur in Execute Process task in SSIS . The main problem with SSIS is it wont show the Exact reason for the Error . It is generic error message for all type of Mistakes.
The 3 settings we need to take care in Execute Process task are
1.Executable
2.Arguments
3.Working Directory
Generally the errors will occur when you are passing wrong arugements or when there is no permission to the given path of Executable or working Directory to the account with with package is running.
i will show you one case where i got this error
Case :
when i am using the Process execute task in ssis it is failing with the fallowing error
[Execute Process Task] Error: In Executing "C:\Program Files\PuTTY\pscp.exe" "echo y | pscp -sftp -pw Password Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv" at "C:\Program Files\PuTTY", The process exit code was "1" while the expected was "0".
when i run the same command from cmd promt is succesful
The command is
echo y | pscp -sftp -pw Passwprd Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv
In Execute Process task i have set the fallowing value
Executeable = C:\Program Files\PuTTY\pscp.exe
Arguments = echo y | pscp -sftp -pw Passwprd Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv
Working directory = C:\Program Files\PuTTY
Solution : here the problem is the Arguments are passed wrongly .
in argmunts we need to pass only
-sftp -pw Passwprd Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv
Once i corrected that the issue is solved.
The 3 settings we need to take care in Execute Process task are
1.Executable
2.Arguments
3.Working Directory
Generally the errors will occur when you are passing wrong arugements or when there is no permission to the given path of Executable or working Directory to the account with with package is running.
i will show you one case where i got this error
Case :
when i am using the Process execute task in ssis it is failing with the fallowing error
[Execute Process Task] Error: In Executing "C:\Program Files\PuTTY\pscp.exe" "echo y | pscp -sftp -pw Password Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv" at "C:\Program Files\PuTTY", The process exit code was "1" while the expected was "0".
when i run the same command from cmd promt is succesful
The command is
echo y | pscp -sftp -pw Passwprd Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv
In Execute Process task i have set the fallowing value
Executeable = C:\Program Files\PuTTY\pscp.exe
Arguments = echo y | pscp -sftp -pw Passwprd Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv
Working directory = C:\Program Files\PuTTY
Solution : here the problem is the Arguments are passed wrongly .
in argmunts we need to pass only
-sftp -pw Passwprd Username@11.111.11.1:/opt/DSC_6_0_R5/logs/metrics.csv C:\Users\Public\Documents\SurendraData\DRA\PSCPTest\server1A_metrics_SSIS.csv
Once i corrected that the issue is solved.
Comments
Post a Comment