Database Reference
In-Depth Information
<Column SourceColumn="ColC"
TargetColumn="Dest_ColC" />
</Outputs>
</Lookup>
</Transformations>
Immediately following the
</Lookup>
tag, add an OleDbDestination XML node
with the following attribute name and value pairs.
•
Name
:
tblDest Destination
•
ConnectionName
:
SSISIncrementalLoad_Dest
Inside the
<OleDbDestination>
tag, add an InputPath node with an
Out-
putPathName
attribute set to the value
"Correlate.NoMatch"
. After the
<In-
putPath>
tag, add an ExternalTableOutput node with a
Table
attribute set to the
value
"dbo.tblDest"
.
The preceding metadata defines an OLE DB Destination adapter and configures it
to connect the Lookup transform's NoMatch output to the SSISIncrementalLoad_Dest
connection defined earlier.
Add a ConditionalSplit XML node immediately after the
</OleDbDestination>
tag. Add an attribute called
Name
and set its value to
"Filter"
. Inside the
<ConditionalSplit>
tags, add an InputPath XML node
with an
OutputPathName
attribute set to
"Correlate.Match"
. Now we need to
add a conditional output path. Immediately following the
<InputPath>
tag, add an
OutputPaths node, followed in turn by an OutputPath node containing a
Name
attribute
set to
"Changed Rows"
. Inside the
<OutputPaths>
tags, create an Expression
node. Between the
<Expression>
and
</Expression>
tags, add the following
SSIS expression.
(ColA != Dest_ColA) || (ColB != Dest_ColB) || (ColC !=
Dest_ColC)
Once this step is complete, the Transformations XML should appear as shown in
Listing 19-11
. Transformations Node Including an OLE DB Source, Lookup, Condi-
tional Split, and one OLE DB Destination
Search WWH ::
Custom Search