Free 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 - download

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
  
• How to Edit DTS Packages After Moving t o SSIS

and much more

---

• Source: http://www.LearnIntegrationServices.com/
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:10 (9.22MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

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