User Rating!

Home > Search > Downloads > SQL Server > Service Packs

Using the SQL 2008 Lookup and Cache Transforms in a SQL Server Integration Services (SSIS) Package

Total Hits: 324  |  Today: 0 Author: Ray Barley       Rating:

Read Reviews | Write Review | Your Rating:  Select One 5 Stars - Best Rating 4 Stars 3 Stars 2 Stars 1 Star - Worst Rating

One of the new SQL Server 2008 features in SSIS is an enhanced Lookup transform that includes the ability to cache the lookup data locally. Can you provide the details of this new functionality and an example of how to use it? The enhanced Lookup transform works hand-in-hand with the Cache transform. The Cache transform is a brand new feature in SQL 2008, allowing you to cache the data used in the Lookup transform. The Lookup transform can then utilize this cached data to perform the lookup operation. Working with cached data will most likely be more efficient than querying the database.

DevASP.Net users Rating What is your opinion? 5 Stars4 Stars3 Stars2 Stars1 Star

Is this your listing?

If this is your listing and you like to add the rating box
displayed on the right side on your site you can use the following code.