You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to
change a variable value during package execution byusing the least amount of development effort. What
should you use?
A.
Expression task
B.
Script task
C.
Execute SQL task
D.
Execute Process task
E.
Term Extraction transformation
Explanation:
According to this reference, this answer looks correct.
Reference:
http://msdn.microsoft.com/en-us/library/hh213137.aspx
From Bidn:
Before SSIS 2012, if you wanted to modify the variable after the start of the package, you often had to set up a Script task to do it. Starting with 2012, we now have the Expression Task.
That is a very good tip particularly to those new to the blogosphere.
Short but very precise info… Many thanks for sharing this
one. A must read post!