Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Group or Ungroup Components

The Control Flow, Data Flow, and Event Handlers tabs in SSIS Designer supports collapsible grouping. If a package has many components, the tabs can become crowded, making it difficult to view all the components at one time and to locate the item with which you want to work. The collapsible grouping feature can conserve space on the work surface and make it easier to work with large packages.

You select the components that you want to group, group them, and then expand or collapse the groups to suit your work. Expanding a group provides access to the properties of the components in the group. The precedence constraints that connect tasks and containers are automatically included in the group.

The following are considerations for grouping components.

  • To group components, the control flow, data flow, or event handler must contain more than one component.

  • Groups can also be nested, making it possible to create groups within groups. The design surface can implement multiple un-nested groups, but a component can belong to only one group, unless the groups are nested.

  • When a package is saved, SSIS Designer saves the grouping, but the grouping has no effect on package execution. The ability to group components is a design-time feature; it does not affect the run-time behavior of the package.

To group components

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow, Data Flow, or Event Handlers tab.

  4. On the design surface of the tab, select the components you want to group, right-click a selected component, and then click Group.

  5. To save the updated package, click Save Selected Items on the File menu.

To ungroup components

  1. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow, Data Flow, or Event Handlers tab.

  4. On the design surface of the tab, select the group that contains the component you want to ungroup, right-click, and then click Ungroup.

  5. To save the updated package, click Save Selected Items on the File menu.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.