The expression tester tool is a standalone application that allows you to easily develop and test expressions. It is like a workbench to quickly try things without having to open a package or mess up the one your currently working on. It is designed to be easily portable, just extract the files and run, but it does require SQL Server Integration Services to be installed on the machine.
The download covers the following versions of SSIS:
Expression Editor Control
- SQL Server 2005
- SQL Server 2008, which includes 2008 R2
- SQL Server Code Name "Denali" CTP3
The expression editor control used in the tester tool has been deliberately made available as a separate component so it can be easily re-used in other tools and custom tasks, for example it is integrated into BIDS Helper
Whilst it was inspired by the Microsoft editor the number one feature I wanted was resizable panes. It also has the usual things like copy and paste as well as fine grained undo/redo. You can drag and drop between the functions tree and the expression or double-click to add it to the expression. It also now includes a built in editor for the Functions Editor
, use the right-click context menu to toggle edit mode on or off.
The functions tree is saved to an XML file as soon as you make any changes. The default location is under your application data (e.g. C:\Users\Darren Green
\AppData\Roaming\Konesans Limited\Expression Editor\ExpressionEditor.xml) and will be shared across all applications that use the control. If using the expression tester and you'd like it to be more portable you can place the functions XML file in the same folder as the executable and that will take precedence. The default file is available on the downloads page.
F5 is the short-cut key to evaluate an expression.
A screenshot of the expression tester tool in action:
An example custom task that uses the expression editor control:
The editor control dialog as used by BIDS Helper
in the Expression List
and Variables Window Extensions