Learn more about Lookup and its new features: A compilation

The SQL Server Integration Services team added valuable new caching options (and scalability) to the Lookup transformation in SQL Server 2008. Learn more about these enhancements (and about the Lookup transformation in general) from the following resources.

Microsoft resources

• In SQL Server Books Online (BOL)
  • Upgrading Lookup Transformations
  • The section Caching the Reference Dataset in the Lookup Transformation topic.
  • How to: Implement a Lookup in No Cache or Partial Cache Mode
  • How to: Implement a Lookup Transformation in Full Cache Mode Using the Cache Connection Manager Transformation
  • How to: Implement a Lookup Transformation in Full Cache Mode Using the OLE DB Connection Manager
  • How to: Create and Deploy a Cache for the Lookup Transformation
• Video (10 minutes): How to: Implement a Lookup Transformation in Full Cache Mode
• Blog postings with screen shots from the SSIS Team Blog by developer Matt Masson (in date order, oldest to newest)
  • Lookup cache modes
  • Calculating the size of your Lookup cache
  • Lookup - Using the cache connection manager
  • Lookup Patterns
    • Lookup Pattern: Key Generation
    • Lookup Pattern: Upsert
    • Lookup Pattern: Cascading
    • Lookup Pattern: Case Insensitive
    • Lookup Pattern: Incremental persistent cache updates
    • Lookup Pattern: Range Lookups
  • API Sample – Lookup Transform
  • Find all Matt's blog postings that are tagged with the "Lookup" tag

Community resources

These are only intended to be some highlights that I was able to find easily...

• Blog postings from SQL Server MVPs and other experts
  • MVP Jamie Thomson from Conchango: Katmai: SSIS: Lookup component gets a makeover
  • MVP John Welch from Mariner: SSIS 2008 - Incrementally Updating the Lookup Cache File
  • MVP Simon Sabin: Lookup performance and buffer usage
  • Jorg Klein: SSIS – Lookup Transformation is case sensitive
  • Jorg Klein: SSIS - Decrease your fact table loading time up to 40%
  • MVP Rafael Salas from Mariner - not a "how to", but suggestions for further improvements to Lookup: SSIS Suggestions: Lookup Enhancements
• Video (7 minutes): Did you know? SQL Server 2008 includes Cache Transform by Dan English from Magenic