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.
[quoted text, click to view] Darren Green wrote:
> Hello leo@junquera.com,
>
> > 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
> >
>
> 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.
Hello leo@junquera.com,
[quoted text, click to view] > 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
>
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.
