Microsoft Exam Questions

You need to design a package to change a variable value during package execution by using the least

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.
Express on task

B.
Data Cleansing transformation

C.
Fuzzy Lookup transformation

D.
Term Lookup transformation

E.
Data Profiling task