Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2008, Part 2 - view details
There are four options available to you when migrating from SQL Server 2000 DTS to SSIS in SQL Server 2008. In the previous video Scott covered the "copy" option. In this video he will cover the other three options; migrate, start from scratch, and use a third party tool.
Highlights from this video:MigrateTwo step processpackage copied from SQL Server 2000 to 2008package is upgraded to SSIS 2008Package Migration Wizard (PMW)how to launchWhy would I use this technique?
Start from scratchbecause SSIS is so different from DTS
Use a third party tool
and much more Source: http://www.learnitfirst.com/Course/158/Video/2214/Pt2-Migrating-to-SSIS-Options.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 09:30 (26.8MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: SSIS 2008, migrating, sql server 2000 dts, sql server 2008, copy, migrate, start from scratch, third party tools, sql server 2000 designer components, backwards compatability, package migration wizard
This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.
