Getting Optimal Performance with Integration Services Lookups

posted by  hjwin (10)  10 months ago (blogs.msdn.com)

Most users see good performance from SSIS packages using out-of-the-box configurations and with little tuning. Sometimes, though, it is necessary to do tuning to get optimal performance. One of the most commonly used transformations is the Lookup transformation. There are several techniques for getting optimal performance from a Lookup transform in SSIS. A few of these are surprising the first time you see them. This article discusses some tuning techniques that we have found can be important in different situations.

A common need in a data warehousing conte