Database Reference
In-Depth Information
G.
Zoom control
: A slider control that changes the display magnification
H.
Designer surface
: The location where various SSIS tasks and containers are placed
I.
Connection Managers tray
: A list view of SSIS connection objects
J.
Properties window
: A configuration tool allowing you to set the properties of
individual SSIS objects
K.
SSIS Toolbox
: A list of SSIS tasks and containers
L.
Visual Studio Toolbox
: Used in previous versions of SSIS to hold tasks and containers
M.
Solution Explorer
: A list of files and projects
Figure 7-8.
Components of the SSIS design environment
Let's take a closer look at a few key items from our list.
The Control Flow Tab
The Control Flow tab lets you configure the basic tasks that make up your ETL process. To work with the Control
Flow tab, add sequence containers and control flow tasks from the SSIS Toolbox to the designer surface. The SSIS
Toolbox offers many items to choose from, but only a select few are used frequently (Figure
7-9
).