New SQL Server Integration Services Video Tutorial: Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details

This is the first video in our series on migrating a DTS package to SSIS package. If you're looking for an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this series. This series takes an interesting DTS package - iterating through each file returned from a result set, downloading that file via FTP, and then inserting that text file's data in a SQL Server table - and lets you see exactly how to migrate this package to SSIS.

Highlights from this video:

• Using the Package Migration Wizard (PMW)
  
• Limitations of the PMW
  
• What to Do When the PMW Reports Success But Your SSIS Packages Fail< br />
• Should You Rewrite Your DTS Package or Use the PMW?

and much more

---

• Source: SSIS videos
• Category: Migrating and Upgrading From SQL Server 2000 Data Transformation Services (DTS) to SSIS in SQL 2005
• Skill Level: 300 (Intermediate)
• Length: 12:08 (10.2MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

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

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

---

Keywords Associated with this video: migrate, migrating, upgrade, upgrading, fails, failure