Home Forums SQL Server 2005 SQL Server 2005 Integration Services Execute Process Task - The process exit code was "2" while the expected was "0" RE: Execute Process Task - The process exit code was "2" while the expected was "0"

  • March 31, 2009 at 3:31 am

    #968920

    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?

    Please advise!

    Sorry for joining in on your post, hopefully we can both get answers for our errors!!!