You need to design a package to change a variable value…

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?

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 taskE. Term Extraction transformation

Explanation:
According to this reference, this answer looks correct.

http://msdn.microsoft.com/en-us/library/hh213137.aspx



Leave a Reply 0

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