You are developing a SQL Server 2008 Integration Services package. The package consists of a Sequence container holding a For Loop and 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?

technology architecture

  1. The variable is only accessible to the first Execute SQL Task

  2. The variable is accessible to both Execute SQL Task, but not the Script Task

  3. The variable is accessible to both Execute SQL Task and the Script Task

  4. The variable is not accessible to any Task

Show answer
Correct Option: B

Find more quizzes: