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-
side the <Inputs> tag, as shown in Listing 19-8 .
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