Disable Package Expression

Question

Disable Package Expression

DinoRS

SSCrazy

Points: 2683
More actions
December 3, 2020 at 4:40 pm

#3816565

Hi SSC,
I've got 2 Project Variables which I use to control wether a package should run or not through the Disable Package Expression

so I've got myself some neat and tidy Project variables let's call them
[$Project::DISABLE_TILDE_RELOAD] and [$Project::DISABLE_ARCHIVE_RELOAD]
If I have only one of them, for example [$Project::DISABLE_TILDE_RELOAD] , the expression @[$Project::DISABLE_TILDE_RELOAD] == True gives me the desired result of the package being disabled.
I would expect the expression @[$Project::DISABLE_TILDE_RELOAD] == True || [$Project::DISABLE_ARCHIVE_RELOAD] == True to work when I set either of those Project Variables to true (thus disabling the package).
I could think of something along the lines of:
[$Project::DISABLE_ARCHIVE_RELOAD] == True ? @[$Project::DISABLE_TILDE_RELOAD] == True ? True : False
to work but in that case I'm still wondering if the above really would be evaluating both conditions individually to decide wether the outcome is true or false or would DISABLE_ARCHIVE_RELOAD == True be a pre-condition to evaluating DISABLE_TILDE_LOAD?
As I understand the above would have the DISABLE_ARCHIVE_LOAD Variable as pre-condition for evaluating DISABLE_TILDE_LOAD. Can I evaluate 2 Project Variables independently for one Expression asides from a Script Task?

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

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

palandri Old Hand Points: 387 More actions · Answer 1

Unless I misunderstand the question, you should be able to enclose your conditions in parens, e.g.:

I tested the expression below, using two booleans Var1 and Var2. It returns true if either is variable is true, only returns false if both are false.

(@[User::Var1] || @[User::Var2]) ? "True" : "False"

TangoVictor SSChampion Points: 10975 More actions · Answer 2

If you just use the following it should be doing what you want. If either is true it will be disabled.

@[$Project::DISABLE_TILDE_RELOAD] || @[$Project::DISABLE_ARCHIVE_RELOAD]

If this is not doing what you want the issue is most likely somewhere else.

I guess this would also work, ugly tho.

@[$Project::DISABLE_ARCHIVE_RELOAD] == False ? @[$Project::DISABLE_TILDE_RELOAD] == False ? False : True : True

This reply was modified 3 years, 11 months ago by TangoVictor.

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

I've got 2 Project Variables which I use to control wether a package should run or not through the Disable Package Expression

I don't have SSIS in front of me right now, but as far as I remember, there is no such thing as a 'Project Variable'. The $Project items you refer to are 'project parameters' and their values, unlike variables, cannot be modified at runtime.

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