SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS Denali Data Flow Grouping

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.


Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


No comments.

Leave a Comment

Please register or log in to leave a comment.