Exit Code 63

Al C

I would love it if I could tell Sql Data Compare not to produce exit code 63 when the tables being compared are identical. I am executing Sql Data Compare from within a Sql Server Integration Services package. I am only allowed to specify a single value as the SuccessValue. If I specify 0 as the SuccessValue and the tables are identical then the task will fail. I want the task to be considered successful if the tables are identical. There are a few workarounds, but none would be as clean as suppressing the exit code 63.

Brian Donahue

That might be helpful. I haven't had the opportunity to work with SSIS yet, but in DTS the recommended workaround was to run the command using VBScript, (Run method?) and then trap the return code and decide whether the return code would be considered a DTS_OK or a DTS_FAIL.

Al C

Yes, that is how I used to do it in DTS. I found a workaround in SSIS. What I do is I set the FailTaskIfReturnCodeIsNotSuccess to False, and then in a subsequent step I test the ReturnCode for 0 or 63. If it is not one of those, then I fail the task.