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.Expression Editor Control
The expression editor control used in the tester tool has been deliberately made available as a separate component for easier re-used in other tools and custom tasks.
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 list, 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.
A screenshot of the expression tester tool in action:
An example custom task that uses the expression editor control: