Chapter 59. Incremental loads using T-SQL and SSIS

Andy Leonard

Back in the old days, when we used to walk to the card punch centers barefoot in the snow uphill both ways and carve our own computer chips out of wood, people performed incremental loads using the following steps:

1.  

Open the source and destination files.

2.  

Look at them.

3.  

Where you see new rows in the source file, copy and paste them into the destination file.

4.  

Where you see differences between rows that exist in both files, copy the source row and paste over the destination row.

Doubtless, some of you are thinking, “Andy, you nincompoop, no one cut and pasted production data—ever.” Oh really? I’d wager that in some department in every Global 1000 company, ...

Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.