| title | Add or Delete a Component in a Data Flow | ||
|---|---|---|---|
| description | Add or Delete a Component in a Data Flow | ||
| author | chugugrace | ||
| ms.author | chugu | ||
| ms.date | 03/01/2017 | ||
| ms.service | sql | ||
| ms.subservice | integration-services | ||
| ms.topic | how-to | ||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
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.
-
In [!INCLUDEssBIDevStudioFull], open the [!INCLUDEssISnoversion] project that contains the package you want.
-
In Solution Explorer, double-click the package to open it.
-
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.
-
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.
-
To save the updated package, click Save Selected Items on the File menu.
-
In [!INCLUDEssBIDevStudioFull], open the [!INCLUDEssISnoversion] project that contains the package you want.
-
In Solution Explorer, double-click the package to open it.
-
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.
-
Right-click the data flow component, and then click Delete.
-
Confirm the delete operation.
-
To save the updated package, click Save Selected Items on the File menu.
Connect Components in a Data Flow
Debugging Data Flow
Data Flow