DSXchange

Hi,

The job description is as follows

Source -- DRS for SQL server
Reference -- DRS for SQL server
Transformer -- performing lookup operation
Target -- DRS for SQL server

I am using lookup input link variable NOTFOUND(=0) in transformer constraint to segregate records which has a match from which doesn't have a match.

The issue is all the records including which does not have match are passed to output link for matched records.

I tried using the ISnull function in the constraint and it is working fine.

Trying to find out if there is any other soultion or workaround for the NOTFOUND variable issue.

The NOTFOUND link variable only works reliably with a hashed file lookup. For direct database lookups, you need to fall back to the Old Skool null check as you are doing.