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?
A.
Expression task
B.
Script task
C.
Execute SQL task
D.
Execute Process task
E.
Term Extraction transformation
Explanation:
http://msdn.microsoft.com/en-us/library/hh213137.aspx
C. Execute SQL task (to change a variable value / least amount of development effort)
Expression task is just an evaluation
Sorry, A. Expression Task is OK. Only since 2012 and I misunderstood how it worked.
A. Expression task