Jaa


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

Tasks

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

Concepts

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

Help and Information

Getting SQL Server 2005 Assistance