Connect Components in a Data Flow
Applies To: SQL Server 2016
This procedure describes how to connect the output of components in a data flow to other components within the same data flow.
In SQL Server Data Tools (SSDT), open the Integration Services 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 in which you want to connect components.
On the design surface of the Data Flow tab, select the transformation or source that you want to connect.
Drag the green output arrow of a transformation or a source to a transformation or to a destination. Some data flow components have error outputs that you can connect in the same way.
Some data flow components can have multiple outputs and you can connect each output to a different transformation or destination.
To save the updated package, click Save Selected Items on the File menu.