There are a number of new features in the 2008 Lookup Transform. Jamie Thomson posted a good overview of the features , and I recommend reading it prior to this article. One of the new features in SSIS 2008 is the ability to cache the data from the Lookup
Read More...