I am at wits end trying to resolve a lookup transformation issue where lookups fail to match in full cache mode.
1. BIDS 2008
2. Both tables are in the same db with the same collation (Latin1_General_CI_AI)
3. Both columns have the same collation (Latin1_General_CI_AI)
4. Both values are the same case
5. Both columns are varchar(9)
I'm not sure what else there is to check. I would prefer to understand what is causing the lookups to fail vs using partial cache.
Any suggestions welcome!
View Complete Post