Export (0) Print
Expand All
Expand Minimize

How to: Add or Delete a Component in 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.

The following procedures describe how to add or delete a component in the data flow of a package.

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.

To delete a component from 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 from which you want to delete a component.

  4. Right-click the data flow component, and then click Delete.

  5. Confirm the delete operation.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft