Database Reference
In-Depth Information
Figure 7-7.
The PubsBIProjects Visual Studio solution at the end of Exercise 7-1
in this exercise, you created a new ssis project and added it to a current solution. next we configure our
ssis package. we begin by outlining the ETL process using ssis sequence containers and tasks.
The Anatomy of an SSIS Package
Once we have made and then renamed the package, it is important to become familiar with the SSIS design
environment. We have listed the most frequently used components and labeled them with a letter that
corresponds to the letters shown in Figure
7-8
:
A.
Package Designer
: A collection of design tabs that visually represent underlying XML
code
B.
Control Flow tab
: A designer surface used to collect SSIS tasks and containers
C.
Data Flow tab
: A designer surface used to collect SSIS data sources, transformation
tasks, and data destinations
D.
Parameters tab
: A collection of parameter used to configure your package
E.
Event Handlers tab
: A designer surface used to hold SSIS tasks and containers that are
executed when an event occurs
F.
Package Explorer tab
: A tree view of all the objects in the current SSIS package
