Performing lookups is one of the most common operations in the ETL process, and doing them incorrectly can severely affect the performance of your data load. In this talk you’ll learn best practices and design patterns for using the lookup component in SQL Server 2008 Integration Services, and how to take advantage of the new lookup features. If you’ve ever wondered about the differences between full and partial caches, the advantages of cascading lookups, and how to do ranged lookups, you won’t want to miss this talk.
I’ll also be hanging out at the SSIS / SQL BI booths throughout the day. Come by and say hello!