SSIS Lookups modes or leaky abstractions

I’ve got a question about SSIS Lookup, how-to change Partial or No_Cache mode in Lookup task ? I could give a quick answer, but wanted to explain what I think we did wrong in SQL 2005, and how are we planning to fix this. Before continuing, I recommend everyone to read this article: Joel Spolsky, The Law of…

4