Using Data Transformation Services with SqlServer 2005

• Jose Ianuck

  Right there with Babe

  Points: 776

  More actions

  September 28, 2006 at 8:45 am

  #113859

  How can I to do Import DTS, created in SqlServer 2000? Please I would like detail about this.

  Thanks a lot.

  Ian.

   

• Felicitywie

  Right there with Babe

  Points: 717

  More actions

  September 29, 2006 at 4:45 am

  #663271

  Hi,

  I found the easiest way is to use the DTS Migration Wizard

  1. Go into SQL Server Business Intelligence Development Studio
  2. Create a New Integration Services Project
  3. Go to Project | Migrate DTS 2000 Package and follow the prompts

  Hope this helps

  Felicity