Expression Task
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
The Expression Task creates and evaluates expressions that set variable values at runtime, using the Expression Builder. When you edit the task, the Expression Builder is launched.
Expression Examples
The expression language includes functions and operators. For examples that demonstrate how to use the functions and operators, see the Expression Examples sections in the functions and operators topics. Links to the topics are in Functions (SSIS Expression) and Operators (SSIS Expression).
For examples of more complex expressions, see Examples of Advanced Integration Services Expressions.
For examples of using expressions to set properties, see the Sample Property Expressions section in Use Property Expressions in Packages.
Related Tasks
Use an Expression in a Data Flow Component
Related Content
Technical article, SSIS Expression Cheat Sheet, on pragmaticworks.com
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for