Post reply

precendence constraint expression isn't evaluating to boolean True / False, but why?

  • May 12, 2015 at 8:18 pm

    #317323

    Here's the expression:

    @rowcount_24631 == @sqlRowcount_24631

    Datatypes on both sides of the equal sign are INT.

    I applied a success constraint which evaluates if the two values are equal. If they are to proceed with next sequence.

    Why this error?:

    Error at MarinETL_Master: The expression "@rowcount_20452 == @sqlRowcount_20452" must evaluate to True or False. Change the expression to evaluate to a Boolean value.

    Error at MarinETL_Master: There was an error in the precedence constraint between "ROWCOUNT CHECK 20452" and "ROWCOUNT CHECK 24631".

    (Microsoft.DataTransformationServices.VsIntegration)

  • May 13, 2015 at 3:03 am

    #1797469

    Ensure that the variable is of the correct scope.

    ____________________________________________________________

    AP

  • May 13, 2015 at 12:00 pm

    #1797643

    same as KoldKoffee (different computers :-))

    --Quote me

  • May 13, 2015 at 12:02 pm

    #1797644

    Thanks Anshul, that right. I had to change variables scope to package level and error gone.

    --Quote me

  • May 14, 2015 at 3:07 am

    #1797766

    polkadot (5/13/2015)

    Thanks Anshul, that right. I had to change variables scope to package level and error gone.

    Cheers!...

    ____________________________________________________________

    AP

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply