Expression List

The Expression List provides a window that lists all the expressions defined in a package. When you have an SSIS project open, the Expression List can be shown or hidden by going to the View... Other Windows menu and selecting the "Expression List (BIDS Helper)" menu item:
ExpressionListMenu.png

ExpressionsList.png

Refreshing the list is a manual process, just click Refresh. The window shows the following information:

Column Description
Object Type The type of the object on which the expression is defined upon.
Path The path to the expression object. Especially useful when you have nested objects or expressions within event handlers.
Property The name of the property or object that the expression applies to.
Expression The expression itself. Click the button to edit the expression.


The expression list searches the entire package, including tasks, loops, event handlers, precedence constraints and variables looking for expressions.

The elipsis button located in the far right column of the grid diplay opens an Expression Editor, provided by Konesans (http://www.konesans.com).

ExpressionEditor.png

The Expression Editor component is now also available on CodePlex - SSIS Expression Editor & Tester

Last edited Oct 5, 2011 at 7:09 PM by DarrenSQLIS, version 13

Comments

ktrock Mar 14, 2013 at 7:20 PM 
That's neat, though I notice you must have a project open in order to have View -->Other Windows--> Expression List available. If you're just looking at a .dtsx you don't get that option in 1.6.2 for SQL 2005.