SSIS is a pretty useful tool for designing ETL processes, but one of the transformations I was disappointed with in 2005 was the lookup. It was a little better than the lookup functionality in DTS, ...

Then SSIS will use the cache to satisfy the actual lookups giving a significant performance gain. Of course, there must be enough memory available to store the results of the lookup query and it must ...