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

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

This is the crucial video for this series - it talks about how to update only the changed rows. This is what everyone wants to know - "How can I only update the rows at the destination?" Here you go :)

Highlights from this video:

• Using the Data Flow task and the OLE-DB Command transformation to update only the changed values
  
• Parameter and query syntax and ordering in the OLEDB Command Task
• Various techniques for identifying which rows at the source have changed

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z
• Skill Level: 400 (Intermediate - Advanced)
• Length: 13:45 (11.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