OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline. However, I just stumbled across a feature in SSIS that I didn't realize had been included - due to a Connect item I'd raised a long time ago (in early 2009). How come I didn't know that the SSIS team had fixed this in 2010? Because I was stuck on 2008R2! But this is something I've been wishing for forever - and all of you should be using this!
Data Flow Sequence Containers
OK - so what is a "Data Flow Sequence Container"? Back when I started using SSIS 2008R2, I'd just come from a coding background, and really appreciated the existence of #region/#endregion in C#.
|Summary level region|
I used regions before I started actually coding something to write pseudo-code as the regions, drill down into each "step", perhaps generate sub-step regions, until I got to "code level". This use of regions basically replaced my use of code comments (I still do use some). It was so much easier to describe what and why a chunk of code was doing, while hiding the code. Regions permitted much clearer exposition of what was going on in the code at a high-level, and letting the developer dig in as much or as little as they wanted.
|One level lower detail regions|
It facilitated debugging and code understanding by walking the unfamiliar developer through the thought process behind the code, instead of having the developer try to surmise what and why code was there (with comments). With only comments, the developer has to try to keep multiple ideas/steps in his head while scrolling through code.
|How are regions not awesome?|
If you're not using these in SSIS Scripts, you SHOULD BE.
What I asked for in "Data Flow Sequence Containers" is the SSIS equivalent of this, and it's here. (Actually must have been here since SSIS 2012. Hi. I'm Todd, and I'm new here.)
Data Flow Groups
Name Your Groups
Nesting is Supported