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

OleDbConnectionName="SSISIncrementalLoad_Dest"
NoMatchBehavior="RedirectRowsToNoMatchOutput">
<InputPath OutputPathName="tblSource Source.Output"
/>
<DirectInput>SELECT ColID, ColA, ColB, ColC FROM
dbo.tblDest</DirectInput>
<Inputs>
<Column SourceColumn="ColID" TargetColumn="ColID"
/>
</Inputs>
<Outputs>
<Column SourceColumn="ColA"
TargetColumn="Dest_ColA" />
<Column SourceColumn="ColB"
TargetColumn="Dest_ColB" />
<Column SourceColumn="ColC"
TargetColumn="Dest_ColC" />
</Outputs>
</Lookup>
<OleDbDestination Name="tblDest Destination"
ConnectionName="SSISIncrementalLoad_Dest">
<InputPath OutputPathName="Correlate.NoMatch" />
<ExternalTableOutput Table="dbo.tblDest" />
</OleDbDestination>
<ConditionalSplit Name="Filter">
<InputPath OutputPathName="Correlate.Match"/>
<OutputPaths>
<OutputPath Name="Changed Rows">
<Expression>(ColA != Dest_ColA) || (ColB !=
Dest_ColB) ||
(ColC != Dest_ColC)</Expression>
</OutputPath>
</OutputPaths>
</ConditionalSplit>
<OleDbDestination Name="stgUpdates"
ConnectionName="SSISIncrementalLoad_Dest">
<InputPath OutputPathName="Filter.Changed Rows" />
<ExternalTableOutput Table="dbo.stgUpdates" />