HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL
task in the package checks product stock levels and sets a package variable named InStock
to TRUE or FALSE depending on the stock level found.
After the successful execution of the Execute SQL task, one of two data flow tasks must run,
depending on the value of the InStock variable.
You need to set the precedence constraints.
Which value for the evaluation operation should you use? (To answer, select the appropriate
option for the evaluation operation in the answer area.)
Answer: 
expression
e.g. @[User::VariableName]=InstockVariableValue
0
0
For example, https://www.simple-talk.com/sql/ssis/working-with-precedence-constraints-in-sql-server-integration-services/
Expression and Constraint: The precedence constraint is evaluated based on both the Value property and the expression. Both must evaluate to true for the constrained executable to run. For example, in the PrecedenceConstraints.dtsx package, the first Execute SQL task must run successfully and the expression must evaluate to true for the precedence constraint to evaluate to true and the constrained executable to run.
1
0
What if Execute SQL task will fail? Should SSIS process go further or it’s better to stop and redo package again? So may be option ‘expression and constraint’ look reasonable?
1
0