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
A.
Expression task
Why not B? I think B also can achieve that goal?
Cannot be B because they want least amount of development effort.
With B. you’re going to type a Visual Basic or C# code to change the value of the variable without mentioning the configuration of that script task.
Same thing goes for C. Answer.
HENCE, A. is the answer with the least effort