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. 
 
 
 
Advertisements
This entry was posted in Programming. Bookmark the permalink.

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

  1. rockstar says:

    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

  2. bala says:

    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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s