I’ve grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It’s a fairly human look at what’s involved in sailing on a Trident missile submarine…
There have been several usability features that have been added to SSIS in the latest CTP. One of these features is Grouping in the Data Flow. This is a feature that exists in current versions of SSIS but only in the Control Flow.
It will work the same way it currently does in the Control Flow, so it is purely an organizational tool. To apply grouping simply select multiple data flow objects then right-click and select Group. The group can be collapsed by hitting the up arrow. The result looks like this:
Again, this is purely a usability thing so there are no properties of the group but it does make it easier to move sections of your data flow around the design surface.