You need to design a package to change a variable value during package execution byusing the least amount of development effort

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Howie

Howie

A.
Expression task