Database Reference
In-Depth Information
as
@RowCount
from a Precedence Constraint Editor dialog window, but as
User::RowCount
from an SSIS Script
task. That's all part of the fun of working with SSIS!
Outlining Your ETL Process
If you are new to creating SSIS projects, you may be overwhelmed with all the information we have shown you.
Rest assured that many developers feel this way when they first start working with SSIS but soon find that it is not
as difficult as it appears.
The best way to keep from being overwhelmed is by outlining the activities you need to perform in your ETL
process. You can outline these activities by adding SSIS tasks to the control flow surface, grouping them together
with sequence containers, and connecting them with precedence constraints. Don't forget that you can add
annotations to the control flow surface to give more specific information about each task.
This practice of outlining the tasks can be very helpful. And we recommend doing so before configuring each
task. You will get a feel for this as you perform this next exercise.
eXerCISe 7-2. FILLING the Data WarehOUSe
in this exercise, we outline the steps needed to perform the ETL processing. The goal is to fill the
DwPubssales data warehouse using the ssis project that was created in Exercise 7-1. Figure
7-20
is an
example of what your ssis package should look like after having completed this exercise, and it can be used
as a reference for each of the following steps.
1.
if the solution from the previous exercise is closed, open Visual studio by clicking
the windows start button and selecting All Programs
➤
Microsoft sQL server
2012
➤
Data Tools. Then follow the instructions from Exercise 7-1 to open
C:\_Bisolutions\Publicationsindustries\Publicationsindustries.sln.
Remember to right-click the menu item, select Run as Administrator, and answer Yes to close the UAC dialog!
add Sequence Containers
1.
select the Control Flow table of the ETLProcessForDwPubssales.dtsx ssis package
you created in Exercise 7-1. Your screen should look like Figure
7-7
.
2.
on the Control Flow tab, drag four sequence Containers to the control flow surface
from the ssis Toolbox, rename them by right-clicking the container, and select
the Rename context menu item. when prompted, rename them as listed here
(Figure
7-22
):
•
Prepare ETL Process sequence Container
•
Fill Dimension Tables sequence Container
•
Fill Fact Tables sequence Containers
•
End ETL Process sequence Containers
adding annotations
3.
Right-click the empty space in each of the sequence containers, and select Add
Annotation from the context menu.
