Database Reference
In-Depth Information
add tasks to the Sequence Containers
6.
Drag and drop two Execute sQL Tasks into the Prepare ETL Process sequence
Container, and rename them to the following:
•
Drop Foreign Keys Execute sQL Task
•
Truncate Tables Execute sQL Task
7.
Drag and drop four Data Flow Tasks into the Fill Dimension Tables sequence
Container, and rename them to the following:
•
Fill DimAuthors Data Flow Task
•
Fill Dimstores Data Flow Task
•
Fill DimPublishers Data Flow Task
•
Fill DimTitles Data Flow Task
8.
Drag and drop one Execute sQL Task into the Fill Dimension Tables sequence
Container, and rename it to the following:
•
Fill DimDates Execute sQL Task
9.
Drag and drop one Execute sQL Task into the Fill Dimension Tables sequence
Container, and rename it to the following:
•
Add null Date Lookup Values Execute sQL Task
10.
Drag and drop two Data Flow Tasks into the Fill Fact Tables sequence Container, and
rename them to the following:
•
Fill FactTitlesAuthors Data Flow Task
•
Fill Factsales Data Flow Task
11.
Drag and drop one Execute sQL Task into the End ETL Process Tasks sequence
Containers, and rename them to the following:
•
Add Foreign Key Constraints Execute sQL Task
12.
Because DimTitles uses data from the DimDates table, we need to load it after the
DimDates table is filled, moving the Fill DimTitles Data Flow Task to the bottom of
the Fill Dimension Tables sequence Container.
when you are done, your ssis package should now look similar to Figure
7-23
.
Note:
A red dot may appear on some tasks indicating that the task is not configured. we remedy this later in
the chapter.
