Most RecentMost ViewedMost LikesLookup Pattern: Range LookupsFirst published on MSDN on Nov 25, 2008 Performing range lookups (i.Pattern: Replacing NULL values with a Derived ColumnFirst published on MSDN on Apr 05, 2011 This pattern has been out there for so long I had contemplated taking it out of my Performance Design Patterns talk, but it looks like it still managed to help some people at SQL Saturday #71 last weekend.API Sample – Lookup TransformFirst published on MSDN on Jan 02, 2009 This sample creates a data flow package with an OLEDB Source component feeding into a Lookup Transform.Lookup Pattern: Incremental persistent cache updatesFirst published on MSDN on Nov 23, 2008 The Cache Transform isn't currently able to update (i.Lookup Pattern: Case InsensitiveFirst published on MSDN on Nov 23, 2008 The Lookup Transform does case sensitive string comparisons.Lookup Pattern: CascadingFirst published on MSDN on Nov 22, 2008 The cascading lookup pattern uses two lookup transforms with different cache modes.Lookup Pattern: UpsertFirst published on MSDN on Nov 22, 2008 This is a pretty basic pattern where we use a lookup to determine whether we need to update and existing row, or insert a new one.Lookup Pattern: Key GenerationFirst published on MSDN on Nov 22, 2008 This pattern is used when you have transformation logic which relies on a key which might not already exist.Lookup PatternsFirst published on MSDN on Nov 22, 2008 From the Lookup presentation I put together for the MS BI conference in October, here is a series of posts which describe different patterns for using the Lookup transform.Lookup - Using the cache connection managerFirst published on MSDN on Nov 22, 2008 Using the Cache Connection Manager (CCM) is a new option for the Lookup transform in SSIS 2008.
