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…

The Expression task (Execute Expression task) is specifically designed to evaluate a SSIS expression and assign the result to a variable during package execution, requiring no custom scripting or complex configuration - just defining the expression directly in the task editor.

Data Cleansing transformation is not a standard SSIS component name; it does not exist as a built-in task for modifying variable values.

Fuzzy Lookup is a data flow transformation used to match rows with approximate values in a reference table and is not used for setting variable values.

Term Lookup is a data flow transformation that identifies terms in text data against a reference table and has no capability to assign values to package variables.

Data Profiling task analyzes data quality statistics and writes results to a file; it does not modify or assign values to variables during execution.