While running a job, I am getting the following error. Field "column name" has keyprep export buffer overrun error. Has anyone come across this error before? I searched in the forum but couldnt find any solution.
This is a common error when RCP is used, as the lookup stage returns the lookup key column twice, once from the source and once from the reference.
EDIT - Sorry, I was thinking that this was a response to another post where RCP and column duplication seemed to be the error. It doesn't necessarily apply to your problem. What data type is the key?
Last edited by ArndW on Mon May 31, 2010 2:31 am, edited 2 times in total.
priyadharsini wrote:Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.
priyadharsini wrote:Lookup is having a single reference link and I tried running the job with 10 records only and Key column is of Varchar (1) datatype.
I would do an explicit conversion so that both datatypes are identical in type and you will need to ensure that nullability is identical as well, perhaps by adding a NullToValue() call.