Success Value from SSIS Execuite process Task

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Success Value from SSIS Execuite process Task

Postby taekr » Thu Jun 20, 2013 7:56 am

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
 
Posts: 2
Joined: Thu Jun 20, 2013 7:46 am

Postby james.billings » Thu Jun 20, 2013 1:58 pm

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.billings
 
Posts: 1146
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Re:

Postby taekr » Fri Jun 21, 2013 2:04 am

Thanks you Jaimes.


james.billings wrote: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
 
Posts: 2
Joined: Thu Jun 20, 2013 7:46 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests