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

Question

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

Phillip.Putzback

Ten Centuries

Points: 1251
More actions
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

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

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

Phil Parkin SSC Guru Points: 246695 More actions · Answer 1

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?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Phillip.Putzback Ten Centuries Points: 1251 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 246695 More actions · Answer 3

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.