I am using lookups in a DTS package. My problem is that Look up does
not differentiates between these two scenarios.

1. Found the key and it is mapped to null, so null is returned.
2. Key was not found, so null is returned.

In both cases null is returned. If I have to log the keys which were
not found, it becomes a little problematic.
Is there way around this other then to change the mapping table, so
that keys are never mapped to null.

Sorry for confusion. Here is what i figured out.

lookups return empty string if key is not found or key passed is null.

but when i say

destination("col") = lookup ("unknown key")
destination("col") continues to have null. Its value does not changes
to empty string.

msgbox lookup ("unknown key")
though gives empty string.

Any ideas??

Thanks




pm wrote: