Data Flow Tab
Use the Data Flow tab of SSIS Designer to create data flows in a SQL Server 2005 Integration Services (SSIS) 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.