Post reply

Precedence constrain expression not working when I compare two package variables

  • March 14, 2012 at 10:04 am

    #258555

    I've two tasks, lets says TaskA and TaskB.

    Also i've two more package user variables lets say VarA and VarB

    Now I would like to execute TaskB upon successful completion of TaskA and when VarA == VarB

    So in the precedence constraint i've set the following

    Evaluation Operation: Expression and Constraint

    Value: Success

    Expression: @[User::VarA] == @[User::VarB]

    But it is not working on success and when VarA = VarB.

    However it is working when I compare VarA to a constant like @[User::VarA] == 10

    Can't we compare two variables in expression editor of precedence constraint? Please help

  • March 14, 2012 at 10:40 am

    #1459352

    I figured out that the issue is with case-sensitive. Actually i'm comparing two string variables, VarA and VarB and the values in it are as below

    VarA = 'Test'

    VarB = 'test'

    Since T in VarA is upper-case and t in VarB is lower-case the constraint did not pass the expression.

    So inorder to make it work I had to change the condition to

    LOWER(@VarA) == LOWER(@VarB)

    Then it worked.

    Is there any other way of making the values in the SSIS package variables case-insensitive?

Viewing 2 posts - 1 through 1 (of 1 total)

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