An In-Depth Case Study of Migrating a DTS Package to SSIS - Video Series Video Category: Migrating and Upgrading From SQL Server 2000 Data Transformation Services (DTS) to SSIS in SQL 2005 Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 This is quite a large video series - seven videos in all - that covers migrating a mildly complex DTS package into SSIS using a variety of techniques. If you want an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this series. You'll see how to loop through each file returned from a result set, download that file via an FTP Task, and then bulk load that text file's data in a SQL Server table (couched in a "Here's how we did it in DTS and here's how we do it in SSIS"). Highlights from this video series: Using the Package Migration Wizard (PMW) Limitations of the PMW What to Do When the PMW Reports Success But Your SSIS Packages Fail Should You Rewrite Your DTS Package or Use the PMW? and much more

Videos in this Series:

Title Skill Length Download Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS   300 12 mins. Download Pt. 2 - An In-Depth Case Study of Migrating a DTS Package to SSIS   300 9 mins. Download Pt. 3 - An In-Depth Case Study of Migrating a DTS Package to SSIS   300 22 mins. Download Pt. 4 - An In-Depth Case Study of Migrating a DTS Package to SSIS   300 18 mins. Download Pt. 5 - An In-Depth Case Study of Migrating a DTS Package to SSIS   300 14 mins. Download Pt. 6 - An In-Depth Case Study of Migrating a DTS Package to SSIS   300 20 mins. Download Pt. 7 - An In-Depth Case Study of Migrating a DTS Package to SSIS   400 21 mins. Download

< Return to list of all videos