Home / General / Getting Optimal Performance with Integration Services Lookups
digWin is a community news sharing site for Microsoft Techies. Share interesting news/links and rate them!

Getting Optimal Performance with Integration Services Lookups

Introduction

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





Microsoft news, tips and tricks search

Comments


Post voted by 1 digWinners


Featured Links

User

Login | Register




Forgot Password?

Sponsor

Anti spam filter for mail servers
Anti spam, anti phishing and email management software for Exchange/SMTP/Lotus. Download a FREE trial!

Featured Product

Download Free Exchange Ebook

Categories

Upcoming NEW

Recent comments

Related Sites