SSIS Expression Editor and Tester
I stumbled upon a gem of a tool this morning, written by Darren Green (blog | twitter) of SQLBits & Bids Helper fame; the SSIS Expression Editor and Tester.
Kudos to Darren, this is a great little tool for fine tuning and testing those complex SSIS expressions without having to keep running tests within SSIS. It’s downloadable with 3 versions, for SSIS 2005, 2008 & 2012, and doesn’t even need installing, it just runs as an exe.
SSIS-tastic.
** Edit 29/01/2022: Updated the link to point to Github
2 comments on “SSIS Expression Editor and Tester”
Leave a Reply
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
| Lewis Prince |  |
| Reiss McSporran |  |
i can not find the download
It has now moved from Codeplex to Github, and is at https://github.com/sqlgreen/SSIS-Expression-Editor