I'm having difficulty with a lookup task.
Firstly in my Lookup my query contains a "DISTINCT" and my cols match source as only some records fail, Source also has a distinct so no Duplicate there either.
I also added on error to display error records to a dataview. Now the lookup code does exist not sure why he is failing
The Lookup transformation found duplicate key values when caching metadata in PreExecute. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
Is the records locking each other as source & lookup read from same table with diff filter criteria to gether with (NOLOCK) specified.
View Complete Post