|The Expressions tool allow you to add and edit user-defined expressions. View all of the expressions and configurations within an SSIS Package, and manage pre-written expressions for later use.|
- Keep a library of pre-written expressions
- Add new expressions
- Edit existing expressions
The BI xPress Expression Editor contains all of the functionality provided by the native SSIS expression editor, and offers many more features:
Open the BI xPress Expressions Editor by doing one of the following:
- Select the Edit Variable icon on the variable toolbar in Visual Studio
- Select Expression from the SentryOne Workbench
- Select the Edit link in the Expressions window
Note: You can drag and drop variables, snippets, or functions to the specified cursor location in the expression text area.
The Expression Highlighter highlights SSIS objects that contain expressions, or objects that are modified by an external configuration.
Note: SSIS items that are modified by an expression are indicated with a Red Circle. SSIS items that are modified by an external configurations are indicated with Blue Circle.
Expression Manager organizes all your common SSIS expressions that you can use with variables, control flow tasks or a Data Flow pipeline. When you edit a variable task or expression in Visual Studio, all of the user defined expressions are listed under the My Expression node on the expression editor.
Note: Re-arrange item nodes by dragging them into different folder nodes.
Open the Expression Manger by doing one of the following:
- Select the Expression manager button from the Variable Toolbar in Visual Studio Select the Expression button on the SentryOne Workbench Select the Expression Manager icon in the Expression Editor
The Expression Manager offers the following features:
The Expression List Add-in automatically lists all expressions for any SSIS objects.
- Select Edit to edit the selected expression.
- Select the Auto Refresh List option in the Expressions window to toggle this setting on or off.
Note: By default Expressions are refreshed automatically when you add, delete, or rename various SSIS objects.
- Use the Enter key to edit selected expression.
- Use the Delete key to delete selected expressions in the list.
- Hover the mouse on the task icon in the first column to see the property path.
- Select the column header to sort in ascending or descending order.