Database Reference
In-Depth Information
<Transformations>
<OleDbSource Name="tblSource Source"
ConnectionName="SSISIncrementalLoad_Source">
<ExternalTableInput Table="dbo.tblSource" />
</OleDbSource>
</Transformations>
</Dataflow>
To continue, add a Lookup XML node immediately after the
</OleDbSource>
tag. Include the following attribute and value pairs in the
<Lookup>
tag:
•
Name
:
Correlate
•
OleDbConnectionName
:
SSISIncrementalLoad_Dest
•
NoMatchBehavior
:
RedirectRowsToNoMatchOutput
The
Name
attribute sets the name of the Lookup transform. The
OleDbConnec-
tionName
instructs Biml to use the connection manager defined in the
<Connec-
tions>
tag in the listing. The
NoMatchBehavior
attribute is configured to redirect
nonmatching rows to the NoMatch output of the Lookup transform.
Continue configuring the metadata that define the Lookup transform by adding a
DirectInput node immediately after the
<InputPath>
tag. Enter the following T-
SQL statement between the
<DirectInput>
and
</DirectInput>
tags.
SELECT ColID, ColA, ColB, ColC FROM dbo.tblDest
Add an Inputs node immediately following the
</DirectInput>
tag. Inside the
<Inputs>
tag, add a Column node. Include the following attribute name and value
pairs.
•
SourceColumn
:
ColID
•
TargetColumn
:
ColID
The preceding metadata provides the mapping between the Available Input
columns and Available Lookup columns on the Columns page of the Lookup trans-
form.
Search WWH ::
Custom Search