70-448 · Question #197
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…
The correct answer is A. Modify the variable scope to the package. 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.
Question
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?
Options
- AModify the variable scope to the package.
- BModify the RaiseChangedEvent property of the variable.
- CModify the EvaluateAsExpression property of the variable.
- DModify the variable scope to the script task.
How the community answered
(29 responses)- A69% (20)
- B10% (3)
- C17% (5)
- D3% (1)
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.
Topics
Community Discussion
No community discussion yet for this question.