1159
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
The SSIS Designer
In the middle of the environment, you’ll see the SSIS Designer, a pale blue area with four
(fi ve at run time) tabs:■ (^) The Control Flow tab: Contains Containers, Tasks, and Precedence Constraints. The
main workfl ow of a package is defi ned in the Control Flow. You can drag the Control
Flow tab elements onto the designer from the Toolbox, which is explained shortly.
■ (^) The Data Flow tab: Born from a data fl ow task on the Control Flow, this tab con-
tains data sources, transformations, and destinations used for moving data from
source to target. Every data fl ow task on the control fl ow of a package has its own
set of confi gurations available on the Data Flow tab.
The Control Flow and Data Flow tabs are major players in the SSIS designer; other
tabs are as follows:
■ (^) The Event Handler tab: Designer for confi guring behavior when events occur,
for instance, OnError. Contains the same set of tools as available on the Control
Flow tab. Event handlers are commonly used for auditing and error handling.
■ (^) The Package Explorer: Shows a tree view of all confi gured elements of a pack-
age. Useful for troubleshooting.
■ (^) Progress/Execution Results tab: (Not pictured until run time); shows the list
of logging events occurring as the package executes in the SSIS Designer. When
debugging has ended, the logging history remains as the Execution Results tab.
Useful for debugging because error messages are reported here.
FIGURE 52-3
A new project and package.
c52.indd 1159c52.indd 1159 7/31/2012 10:29:25 AM7/31/2012 10:29:25 AM
http://www.it-ebooks.info