Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS, Part 1 - view details
In this set of two videos Scott will show you how to do a migration; taking a DTS package or set of packages, moving them to SSIS, and upgrading them to SSIS packages. This process involves multiple steps, and Scott will walk you through each one. Most companies will have a small amount of DTS packages that will be able to be moved fairly easily and quickly using the techniques demonstrated in this set of videos.
Highlights from this video:SQL Server 2000 Enterprise Manager
Visual Studio Integration Services ProjectPackage migration wizardmigrate dts 2000 package
DTSX file destination
Are the old SQL Server 2000 packages deleted?
Can changes be saved in SQL 2000 DTS?
What destination should I use?
Connection managersand much more Source: http://www.learnitfirst.com/Course/158/Video/2215/Pt1-Package-Migration-Wizard.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 13:15 (34.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: SSIS 2008, package migration wizard, dts package, ssis package, dtsx file, ole db destination, connection manager
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.
