Database Reference
In-Depth Information
add precedence Constraints
1.
Click the Drop Foreign Keys Execute sQL Task, and a precedence constraint arrow
appears. Connect this arrow to the Truncate Tables Execute sQL Task. Continue this
for steps 14-22.
2.
Add a constraint arrow to the Prepare ETL Process sequence Container, and connect
it to the Fill Dimension Tables sequence Container.
3.
Add a constraint arrow to the Fill DimAuthors Data Flow Task, and connect it to the
Fill Dimstores Data Flow Task.
4.
Add a constraint arrow to the Fill Dimstores Data Flow Task, and connect it to the Fill
DimPublishers Data Flow Task.
5.
Add a constraint arrow to the Fill DimPublishers Data Flow Task, and connect it to
the Fill DimDates Execute sQL Task.
6.
Add a constraint arrow to the Fill DimDates Execute sQL Task, and connect it to the
Add null Date Lookup Values Execute sQL Task.
7.
Add a constraint arrow to the Add null Date Lookup Values Execute sQL Task, and
connect it to the Fill DimTitles Data Flow Task.
8.
Add a constraint arrow to the Fill Dimension Tables sequence Container, and connect
it to the Fill Fact Tables sequence Container.
9.
Add a constraint arrow to the Fill FactTitlesAuthors Data Flow Task, and connect it to
the Fill Factsales Data Flow Task.
10.
Add a constraint arrow to the Fill Fact Tables sequence Container, and connect it to
the End ETL Process Tasks sequence Container.
11.
Move the precedence constraint arrows around by clicking them and dragging them
to a different position. once the package looks similar to the one illustrated in
Figure
7-24
, save your ssis package using File
➤
save from the Visual studio main
menu.
Your ssis package should now look similar to Figure
7-24
.
Note:
A red dot may appear on some tasks indicating that the task is not configured. As noted, we resolve
this later in the chapter.
