You are developing a SQL Server 2008 SQL Server Integration Services (SSIS) package. The
package consists of a Sequence container holding a For loop and a Foreach loop. There are two
Execute SQL tasks in the Foreach loop, and one Script task in the For loop.
You have created a variable for the Foreach loop. What will be the scope of the variable?
A.
The variable is only accessible to the first Execute SQL task.
B.
The variable is accessible to both Execute SQL tasks but not the Script task.
C.
The variable is accessible to the two Execute SQL tasks and the Script task.
D.
The variable is not accessible to any task.