How to: Add a Component to a Data Flow

Data flow components are sources, destinations, and transformations in a data flow. Before you can add components to a data flow, the control flow in the package must include a Data Flow task.

To add a component to a data flow

  1. In Business Intelligence Development Studio, 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 tab, and then double-click the Data Flow task that contains the data flow to which you want to add a component.

  4. In the Toolbox, expand Data Flow Sources, Data Flow Transformations, or Data Flow Destinations, and then drag a data flow item to the design surface of the Data Flow tab.

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

See Also


How to: Connect Components in a Data Flow
How to: Remove a Component from a Data Flow
How to: Configure an Error Output in a Data Flow Component


Data Flow Elements
Data Flow How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance