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

<Transformations>
<OleDbSource Name="tblSource Source"
ConnectionName="SSISIncrementalLoad_Source">
<ExternalTableInput Table="dbo.tblSource" />
</OleDbSource>
<Lookup Name="Correlate"
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>