Lookup

Hi,

Before inserting records of a recordset I would like to check that each one of these records doesn't exist in the destination table 1. If the records exist, they should be redirect to other table 2.

For this purpose I use a lookup task. The referende table is the destination table 1. The green line is linked to table 2 and the red line is linked to table 1.

The first execution works properly and copies de records to table 1, but on the next executions the records are copied to table 1 instead of being copied to table 2.

Any idea?

Thanks.

What do you mean when you say next executions?

Are you using a for each/next loop or just running the packing over again?

You could try adding a unique index on table 1, skip the lookup, and insert records straight from the source to the destination with error rows to sent to table 2.

|||I mean just running the packing over again.|||

Andrew,

It looks like the Lookup is not finding any match in the 2nd execution. The lookup transformation is case sensitive; check that the CasInG of incoming rows and the rows also match, or use Upper/lower function in both the source and the lookup.