Migrating DTS to SSIS 2008

Migrating DTS to SSIS 2008

• Myles Matheson
• Solution Specialist
• Microsoft New Zealand

Session Objectives

• Explain the migration story for SSIS 2008
• Describe tools and practices for migration
• Provide guidance for current engagements

Key takeaways

• We will not break existing installs
• This is not the next version of DTS – it’s the first version of a whole new product
• Migration is not perfect
• Redesign is a better option

Agenda

• From DTS to SSIS
• Upgrade Experience
• Support for Migration
• Migrating Packages

Simple Data Transformation

• DTS Data Transformation and SSIS Data Flow objects models don’t map 1-1.
• Goal: Migrate all packages created by the Import/Export Wizard and any others with equivalent functionality

Quiz:

1. What’s the first thing to do before a migration? Run Upgrade Advisor
2. What happens when SSIS Migration Wizard can’t upgrade a DTS package? It will be encapsulated and called back from a legacy DTS runtime.
3. What else should be first? Get funding/permission!