I know DTS but am new to SSIS. I am having trouble exporting records
that don't match from a lookup transformation. I get the following
error:

Row yielded no match during lookup.


I would really like to have a list of all records that did not match so
that I could export and examine it.


Thanks

Hello leo (AT) junquera (DOT) com,

Two choices-

1 Click the "Configure Error Output" button in the Lookup UI. You can set
row to Redirect for errors. This means any rows which fail to match in the
lookup, which are clased as error rows here, get sent down the error output.
Simple two outpust, good and bad rows.

2 Again configure the error output, but this time set Ignore. The rows without
a match will just flow down the main output, but with null values.

I tried that but must be doing something wrong. I click on the
"configure error output..." button and set the two rows I see there
(one for error, the other for truncation) to redirect rows.

I have a Lookup Error Output link going to a Flat File Destination but
it does not look like it ever gets run (remains white). Then it
proceeds to the next lookup but row count displayed over the green data
flow path is less after the it is before.

If I set the "configure error output..." to Fail Component, the
component will fail (turns red) and never seems to run the Lookup Error
Output path because the Flat File Destination remains white.

Darren Green wrote: