You design a SQL Server 2008 Integration Services (SSIS) package.
The package assigns a value to a variable by using a Script task. When the package
executes successfully, the value of the variable is not updated.
You need to modify the package so that the Script task can assign the value of the variable.
What should you do?
A.
Modify the variable scope to the package.
B.
Modify the RaiseChangedEvent property of the variable.
C.
Modify the EvaluateAsExpression property of the variable.
D.
Modify the variable scope to the script task.
Explanation:
Variables in SSIS, like in other programming languages, can have different scopes. For
instance, a package scope means the variable can be accessed anywhere within the
package, but a variable with a Data Flow scope can only be accessed within the specified
Data Flow task.