Most RecentMost ViewedMost LikesLookup - 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.Lookup Pattern: Range LookupsFirst published on MSDN on Nov 25, 2008 Performing range lookups (i.Calculating the size of your Lookup cacheFirst published on MSDN on Oct 18, 2008 Good news - a couple of Information log events where added to the Lookup Transform in SQL 2008 to help you better understand your lookup cache.Lookup Pattern: Case InsensitiveFirst published on MSDN on Nov 23, 2008 The Lookup Transform does case sensitive string comparisons.Lookup cache modesFirst published on MSDN on Oct 18, 2008 Over the past couple of months I've been putting together a presentation on the Lookup Transform.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.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.Lookups with Visual FoxProFirst published on MSDN on Mar 04, 2008 Here's a quick tip from a couple other members of the SSIS team, Da Lin and David Noor.Lookup Pattern: CascadingFirst published on MSDN on Nov 22, 2008 The cascading lookup pattern uses two lookup transforms with different cache modes.Lookup Pattern: Incremental persistent cache updatesFirst published on MSDN on Nov 23, 2008 The Cache Transform isn't currently able to update (i.
