April 8, 2009 at 7:52 am
Hi Everyone,
I have an issue with Lookup task. Please, give your helping hand in this to fix it.
I have one master and child package; in child package, there is a data flow task under that there is an OLEDB Source task, 7 lookup task and one flat file destination task.
There is one lookup task which throws the error. If i delete that task, package is executed successfully, otherwise it throws below error.
Code: 0x802090E4
Source: Claim Header LookupClaimType [11504]
Description: The Lookup transformation encountered duplicate reference key values when caching reference data. 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_CAC
This warning makes child packge throws non-zero return value to master and in turn it throws an error.
could you please, let me know how can i fix above warning? So, that parent package runs successfully.
NOTE: There is no mismatch in columns of OLEDB Source + lookup tasks and flat file connection manager.
The datasets returned by each lookup and OLEDB source are different. The column names are unique.
April 12, 2009 at 9:37 pm
As indicated by your posted error message, there are duplicates in your reference data used for the lookup. You can do one of two things to fix this: Change the cache type from Full Cache, or modify your query in the Lookup Transformation to ensure that there are no duplicates in your result set.
hth,
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply