Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Use the Expression Builder dialog box to create and edit a property expression or write the expression that sets the value of a variable using a graphical user interface that lists variables and provides a built-in reference to the functions, type casts, and operators that the Integration Services expression language includes.
A property expression is an expression that is assigned to a property. When the expression is evaluated, the property is dynamically updated to use the evaluation result of the expression. Likewise, an expression that is used in a variable enables the variable value to be updated with the evaluation result of the expression.
There are many ways to use expressions:
Tasks Update the To line that a Send Mail task uses by inserting an e-mail address that is stored in a variable; or update the Subject line by concatenating a string such as "Sales for: " and the current date returned by the GETDATE function.
Variables Set the value of a variable to the current month by using an expression like DATEPART("mm",GETDATE())
; or set the value of a string by concatenating the string literal and the current date by using the expression "Today's date is " + (DT_WSTR,30)(GETDATE())
.
Connection Managers Set the code page of a Flat File connection manager by using a variable that contains a different code page identifier; or specify the number of rows in the data file to skip by entering a positive integer like 3 in the expression.
To learn more about property expressions and writing expressions, see Use Property Expressions in Packages and Integration Services (SSIS) Expressions.
Term | Definition |
---|---|
Variables | Expand the Variables folder and drag variables to the Expression box. |
Mathematical Functions String Functions Date/Time Functions NULL Functions Type Casts Operators |
Expand the folders and drag functions, type casts, and operators to the Expression box. |
Expression | Edit or type an expression.` |
Evaluated value | Lists the evaluation result of the expression. |
Evaluate Expression | Click Evaluate Expression to view the evaluation result of the expression. |
Expressions Page
Property Expressions Editor
Integration Services (SSIS) Variables
System Variables
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Introduction to expressions in Power Automate - Training
Learn how to write expressions in Power Automate.