SSIS Lookup Component Error: output column ‘x’ and reference column named ‘y’ have incompatible data types.

This error was driving me mad for ages, I assumed that the data types were in fact different!
Silly me.
This error is caused by changing the data type(s) of one (or more) of the underlying columns referenced by the lookup component.
The only way that I’ve found to fix this is to delete and re-create the lookup component. 


  1. rockstar said:

    Thank you so much mate..I also faced the same problem..packages were running before and all of a sudden, got this error..but u saved me..THnaks a lot

    June 14, 2011
  2. bala said:

    I was not able to solve this issue even after re-creating the lookup component. it is working fine in local environment (32 bit). but in server (64 bit). it throughs the error.

    June 30, 2011

Leave a Reply