70-463 · Question #11
You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of development effort. W
The correct answer is A. Expression task. This question tests knowledge of the SSIS Expression task, which is the purpose-built, lowest-effort way to evaluate an expression and assign its result to a variable at runtime.
Question
You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of development effort. What should you use?
Options
- AExpression task
- BScript task
- CExecute SQL task
- DExecute Process task
- ETerm Extraction transformation
How the community answered
(39 responses)- A92% (36)
- D5% (2)
- E3% (1)
Why each option
This question tests knowledge of the SSIS Expression task, which is the purpose-built, lowest-effort way to evaluate an expression and assign its result to a variable at runtime.
The Expression task is specifically designed to evaluate SSIS expressions and assign results directly to variables during package execution, requiring only a few clicks in the task editor with no code or SQL authoring needed, making it the minimum-effort solution for this requirement.
A Script task can change variables but requires writing and maintaining custom VB.NET or C# code, which is significantly more development effort than an Expression task.
An Execute SQL task can store query results into variables but requires a database connection, a SQL statement, and result set mapping configuration, adding unnecessary complexity.
An Execute Process task launches an external executable and is not designed for variable manipulation within the SSIS runtime.
Term Extraction is a data flow transformation that identifies noun phrases from text columns; it has no capability to set package variable values.
Concept tested: SSIS Expression task for runtime variable assignment
Source: https://learn.microsoft.com/en-us/sql/integration-services/control-flow/expression-task
Topics
Community Discussion
No community discussion yet for this question.