I'm wondering if you ever figured out what the problem was. Interestingly enough, I'm also encountering the same problem trying to run a batch file with WinSCP. I can run the package without any issue manually (by right-clicking and run package from SQL Server), but as soon as I tried to schedule it on the Sql Server Agent Jobs, it gives me that same error msg.
Description: In Executing "C:\Scripts\hrxfer.bat" "" at "", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 2:55:00 PM Finished: 2:55:02 PM Elapsed: 1.516 seconds. The package executed successfully. The step succeeded.
Any help is appreciated.
Hesten Erwin (3/31/2009)
I am also getting a similar error!
My Execute Process Task is supposed to run a batch file, which in turn is supposed to Process a Cognos cube.
The batch file contains "path to .exe" -n "Output path"
When I run the package manually, through BIDS, it is fine. The success value is set to 0.
When I run it using a SQL Server Agent Job, it fails. It reports the following error: In Executing "Path to batch file" ""at"", The process exit code was "1" while the expected was "0".
If I change the SuccessValue to 1, the Manual execution of the task/package fails. When running it using a SQL Server Agent Job, the job doesn't report an error anymore, but the cube does not update.
What am I supposed to do?
Why are these errors occurring?
Is there any way to get better or more descriptive error messages?
Sorry for joining in on your post, hopefully we can both get answers for our errors!!!