Learn more about Lookup and its new features: A compilation

An article by Dougbert

1 Comment

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)

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

2008, lookup

Comments (1) -

<a href="http://www.sqllion.com/" rel="nofollow" class="url">SQL Lion</a>
May 19, 2009 at 12:09 PM #

Thank you for the valuable information of Lookup transformation. You will get more information regarding the API and programming stuffs for Lookup transformation for SSIS in the below link.

www.sqllion.com/.../">www.sqllion.com/.../programming-lookup-transformation

Add comment

Name* Required Please choose another name

E-mail*

Country

b i u quote

Comment
Preview

Notify me when new comments are added

Learn more about Lookup and its new features: A compilation

Microsoft resources

Community resources

Comments (1) -

Add comment

Tag cloud

Other resources

Other blogs