New SQL Server Integration Services Video Tutorial: Options Available for Performing Incremental Updates/Deltas with SSIS

Options Available for Performing Incremental Updates/Deltas with SSIS - 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. For example: you have a table in your mainframe database that is just huge - 200 million rows. Your company does not expose the mainframe database to the web; instead they've built a complex data movement package that copies the data out of the mainframe and into a SQL Server database that the website uses. Previously, they were able to delete the old rows and simply replace the SQL Server data with the mainframe data - but, with 200 million rows to copy over, this has become impossible. How can you help?

You have a few options - and this videos helps you learn what those options are and when to use each!

---

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