September 1, 2013 at 8:36 am
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
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?
September 1, 2013 at 9:20 am
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
I think you've cracked it. False and "False" are quite different things - in the eyes of SSIS at least.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy