New SQL Server Integration Services Video Tutorial: Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details

One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. This video, part 1, talks about the options available to you if you need to append rows from a source table to a target table, update only the changed rows with SSIS, or to delete rows at the destination that have also been deleted at the source.

Highlights from this video:

• How to know when to use Set-Based incremental deltas or cursor-style (a decision tree)
  
• Using the four part object identification to make addressing objects simpler

and much more

NOTE: Please watch the Options Available for Performing Incremental Updates/Deltas with SSIS video before watching this one.

---

• Source: http://www.LearnIntegrationServices.com
• Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z
• Skill Level: 300 (Intermediate)
• Length: 7:45 (6.5MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table