No more implicit lookup cache sharing in Katmai

Published Mar 25 2019 02:00 PM 95 Views
Not applicable
First published on MSDN on Jan 08, 2008

The November CTP for SQL Server 2008 introduced our new Lookup Transform. 2005 packages with lookup components will upgrade automatically when opened/run in 2008, and should function the same as they did in 2005 with one minor caveat.

In certain scenarios, dataflows containing lookups with matching SQL queries would implicitly share a cache. As this implicit sharing was somewhat error prone, it has been removed in 2008. To share a lookup cache, you can now use the new cache connection manager.

For more info about the 2008 lookup changes, you can take a look at Jamie Thomson's write up .

%3CLINGO-SUB%20id%3D%22lingo-sub-387366%22%20slang%3D%22en-US%22%3ENo%20more%20implicit%20lookup%20cache%20sharing%20in%20Katmai%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-387366%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Jan%2008%2C%202008%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EThe%20November%20CTP%20for%20SQL%20Server%202008%20introduced%20our%20new%20Lookup%20Transform.%202005%20packages%20with%20lookup%20components%20will%20upgrade%20automatically%20when%20opened%2Frun%20in%202008%2C%20and%20should%20function%20the%20same%20as%20they%20did%20in%202005%20with%20one%20minor%20caveat.%3C%2FP%3E%0A%20%20%3CP%3EIn%20certain%20scenarios%2C%20dataflows%20containing%20lookups%20with%20matching%20SQL%20queries%20would%20implicitly%20share%20a%20cache.%20As%20this%20implicit%20sharing%20was%20somewhat%20error%20prone%2C%20it%20has%20been%20removed%20in%202008.%20To%20share%20a%20lookup%20cache%2C%20you%20can%20now%20use%20the%20new%20cache%20connection%20manager.%3C%2FP%3E%0A%20%20%3CP%3EFor%20more%20info%20about%20the%202008%20lookup%20changes%2C%20you%20can%20take%20a%20look%20at%20Jamie%20Thomson's%20%3CA%20href%3D%22http%3A%2F%2Fblogs.conchango.com%2Fjamiethomson%2Farchive%2F2007%2F11%2F16%2FKatmai_3A00_-SSIS_3A00_-Lookup-component-gets-a-makeover.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20write%20up%20%3C%2FA%3E%20.%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-387366%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jan%2008%2C%202008%20The%20November%20CTP%20for%20SQL%20Server%202008%20introduced%20our%20new%20Lookup%20Transform.%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Mar 25 2019 02:00 PM
Updated by: