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

Add an Outputs node immediately following the </Inputs> tag. Inside the
<Outputs> tag, add three Column nodes with the following attribute name and value
pairs.
1. a. SourceColumn : ColA
b. TargetColumn : Dest_ColA
2. a. SourceColumn : ColB
b. TargetColumn : Dest_ColB
3. a. SourceColumn : ColC
b. TargetColumn : Dest_ColC
The preceding metadata “selects” the columns returned from the Lookup trans-
form's Available Lookup columns on the Columns page. Once added, the Lookup
transform metadata should appear as shown in Listing 19-10 .
Listing 19-10 . Transformations Including Lookup Metadata
<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" />