http://www.sqlservercentral.com/blogs/toddmcdermid/2011/07/18/presenting-upserts-to-pass-appdev-vc/ Printed 2014/09/18 10:04AM
Presenting Upserts to PASS AppDev VCHopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A not-so-fancy mashup of the words "update" and "insert".
If you struggle with incremental table loading performance - updating rows that already exist, and inserting rows that didn't - then you might want to drop by.
July 26th, 4pmGMT/12pm ET/9am PT
Go to the PASS AppDev website, and find the LiveMeeting link.
The full abstract:
One of the most sought after techniques in Integration Services is how to perform "upserts" - propagating changes from one system to another that may require new records to be inserted, or existing records to be updated. Integration Services can't accomplish this with a single click, but it does contain all the tools required to construct packages that will achieve this goal. The task of synchronizing data will be broken down into two parts: detecting changes, and updating or inserting. Refinements to use of the Lookup and alternatives to the OLE DB Command transform will be explored.