How can we help you today? How can we help you today?

Success Value from SSIS Execuite process Task

Hi

I am testing to run Data Compare in SSIS Executive process Task.

In the first run, it found the different and synchronised the data then returned successValue = 0.

In the subsequent run, there was no difference and returned success value = 63, leading the package to 'Fail'. The following is what I found in the log.

RedGate.Shared.Utils.CommandLine.FatalExecutionException: The selected objects are identical or no objects have been selected in the comparison. ---> RedGate.SQLToolsCommandLine.NothingToCompareException: The selected objects are identical or no objects have been selected in the comparison.

I like to confirm that whether value 63 is related to NothingToCompareException. Also if there is a list of returned value from Data Compare I can get. I'd like to know the possible return values.

Thanks
taekr
0

Comments

2 comments

Sort by
  • James B
    Exit code 63 is indeed thrown when the databases are identical. You can stop this happening by including identical results the comparison, using the /Include:Identical option as described on this page
    James B
    0
  • taekr
    Thanks you Jaimes.

    Exit code 63 is indeed thrown when the databases are identical. You can stop this happening by including identical results the comparison, using the /Include:Identical option as described on this page
    taekr
    0

Add comment

Please sign in to leave a comment.