Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Data Flow Tab


Applies To: SQL Server 2016

Use the Data Flow tab of SSIS Designer to create data flows in a Integration Services package.

Create the data flows by dragging graphical objects that represent sources, transformations, and destinations from the Toolbox to the design surface of the Data Flow tab, and then connecting the objects to create paths that determine the sequence in which the transformations run.

Right-click a path, and then click Data Viewers, to add data viewers to view the data before and after each data flow object.

You can also use SSIS Designer to add the following functionality from the Data Flow tab:

  • Manage variables

  • Add annotations

To add these functions in SSIS Designer, right-click the design surface, and then select the option you want.

Integration Services Paths
Data Flow Task
SSIS Designer
Data Flow

Community Additions

© 2016 Microsoft