New SQL Server Integration Services Video Tutorial: Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2005

Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2005 - view details

This video is an excellent technology-overview of what options exist for moving from SQL Server 2000's DTS to SQL Server 2005's SSIS. Do you want to just migrate one package or all packages? Are you moving your entire server or just one package? What is legacy mode?

Highlights from this video:

• Choices you have to make when moving from SQL 2000 to SQL 2005
  
• Package Migration Wizard vs. an In-Place Upgrade
  
• Using Legacy Mode/compatibility in SSMS (SQL Server Management Studio)
  
• Issues with migrating DTS packages to SSIS
  
• Benefits of in-place upgrades
  
• Using the DTS Designer Components
  
• H ow to Edit DTS Packages After Moving to SSIS

and much more

---

• Source: http://www.LearnIntegrationServices.com/
• Category: Migrating and Upgrading From SQL Server 2000 Data Transformation Services (DTS) to SSIS in SQL 2005
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:10 (9.22MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video s o a subscription is required.

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

---

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate