Post reply

How do I write Precedence Constraint Editor Expression to execute when a value is false?

  • September 1, 2013 at 8:36 am

    #151277

    I have two sequence containers. When I set Bln_runWithOverrideDates to True I want to run my SEQC_Historical container. That part works, the expression is "@[User::bln_RunWithOverrideDates]" when it is false I want to run the SEQC_Daily container. But when I try to put in any variation of "@[User::bln_RunWithOverrideDates] != 0" or @[User::bln_RunWithOverrideDates] = "False" I get errors.

    Thanks,

    Phil

  • September 1, 2013 at 8:46 am

    #1646621

    Phillip.Putzback (9/1/2013)

    I have two sequence containers. When I set Bln_runWithOverrideDates to True I want to run my SEQC_Historical container. That part works, the expression is "@[User::bln_RunWithOverrideDates]" when it is false I want to run the SEQC_Daily container. But when I try to put in any variation of "@[User::bln_RunWithOverrideDates] != 0" or @[User::bln_RunWithOverrideDates] = "False" I get errors.

    Thanks,

    Phil

    Use == to test for equality, not just =.

    What errors do you get, exactly?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • September 1, 2013 at 9:20 am

    #1646623

    Phil Parkin (9/1/2013)

    Phillip.Putzback (9/1/2013)

    I have two sequence containers. When I set Bln_runWithOverrideDates to True I want to run my SEQC_Historical container. That part works, the expression is "@[User::bln_RunWithOverrideDates]" when it is false I want to run the SEQC_Daily container. But when I try to put in any variation of "@[User::bln_RunWithOverrideDates] != 0" or @[User::bln_RunWithOverrideDates] = "False" I get errors.

    Thanks,

    Phil

    Use == to test for equality, not just =.

    What errors do you get, exactly?

    I was getting a DT_BOOL and DT_WSTR are incompatible for binary operator ==. But I am running the package right but think I might be able to use @Variable == False without the quotes around False.

    Thanks,

    Phil

  • September 1, 2013 at 9:45 am

    #1646626

    I think you've cracked it. False and "False" are quite different things - in the eyes of SSIS at least.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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