My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS: Problems with Lookups and comparing data
The new RSS feed is here
I'm sure I've seen this mentioned before but as I had forgot about it I thought others might benefit from a reminder.
The Lookup transformation matches data differently when in cached and non-cached (Enable Memory Restriction) mode.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS: Problems with Lookups and comparing data