Business Intelligence Markup Language - SQL Server Integration Services Design Patterns - page 466

ConnectionString=
"Data Source=(local);Initial
Catalog=SSISIncrementalLoad_Source;Provider=
SQLNCLI11.1;Integrated Security=SSPI" />
<Connection Name="SSISIncrementalLoad_Dest"
ConnectionString=
"Data Source=(local);Initial
Catalog=SSISIncrementalLoad_Dest;Provider=
SQLNCLI11.1;OLE DB Services=1;Integrated
Security=SSPI;" />
</Connections>
<Packages>
<Package Name="IncrementalLoadPackage" ConstraintMode=
"Parallel"
ProtectionLevel="EncryptSensitiveWithUserKey">
<Tasks>
<ExecuteSQL Name="Truncate stgUpdates"
ConnectionName="SSISIncrementalLoad_Dest">
<DirectInput>Truncate Table
stgUpdates</DirectInput>
</ExecuteSQL>
<Dataflow Name="Load tblDest">
<PrecedenceConstraints>
<Inputs>
<Input OutputPathName="Truncate
stgUpdates.Output" />
</Inputs>
</PrecedenceConstraints>
<Transformations>
<OleDbSource Name="tblSource Source"
ConnectionName="SSISIncrementalLoad_Source">
<ExternalTableInput Table="dbo.tblSource" />
</OleDbSource>
<Lookup Name="Correlate"
OleDbConnectionName="SSISIncrementalLoad_Dest"
NoMatchBehavior="RedirectRowsToNoMatchOutput">
<InputPath OutputPathName="tblSource