Database Reference
In-Depth Information
Listing 19-7
.
Configured Packages, Package, Tasks, and ExecuteSQL Nodes
<Packages>
<Package Name="IncrementalLoadPackage" ConstraintMode=
"Parallel"
ProtectionLevel="EncryptSensitiveWithUserKey">
<Tasks>
<ExecuteSQL Name="Truncate stgUpdates"
ConnectionName="SSISIncrementalLoad_Dest">
<DirectInput>Truncate Table
stgUpdates</DirectInput>
</ExecuteSQL>
</Tasks>
</Package>
</Packages>
The Execute SQL task defined in the Biml in
Listing 19-7
will truncate a staging
table that will hold rows that have been changed in the Source table since being loaded
into the Destination table.
Specifying a Data Flow Task
After the
</ExecuteSQL>
tag, add a Dataflow XML node. Include a
Name
attribute
and set the value of the
Name
attribute to "
Load tblDest
". Inside the
<Data-
flow>
tag, add a PrecedenceConstraints node. Place an Inputs node inside the
<Pre-
cedenceConstraints>
tag, and an Input node that includes an
Out-
putPathName
attribute with the value "
Truncate stgUpdates.Output
" in-
Listing 19-8
.
Adding a Precedence Constraint from the Truncate stgUpdates Execute
SQL Task to the “Load tblDest” Data Flow Task
<Dataflow Name="Load tblDest">
<PrecedenceConstraints>
<Inputs>
<Input OutputPathName="Truncate stgUpdates.Output"
/>
Search WWH ::
Custom Search