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.)
Which value for the evaluation operation should you use?
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.)
Expression and Constraint:
*Constraint to test SUCCESS of ‘Execute SQL Task’
**Expression to test ‘…depending on the value of the InStock variable’