dts packge

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  September 16, 2009 at 3:04 pm

  #133992

  i have a dts packge in sql2000.

  i need to deploy that package in sql2005.

  how to do it.

  can u pls give the steps.

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  September 16, 2009 at 3:13 pm

  #1054724

  sqll2000 dtspackge should be copied to sqll2005.?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 16, 2009 at 4:20 pm

  #1054746

  Here's how I've done it.

  1. Download and install the SQL 2000 DTS Designer components and DTS runtime components http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en.

  2. Save the DTS packages in the SQL 2000 instance to files.

  3. Import the DTS package files into SQL 2005. In SSMS, under Mangement - Legacy - Data Transformation Services right-click and Import Package File.

  You'll be able to open and edit the packages and run them in the SQL 2005 instance.

  Greg

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  September 16, 2009 at 4:27 pm

  #1054749

  thanks...........

• Sergey Vavinskiy

  SSCarpal Tunnel

  Points: 4469

  More actions

  September 16, 2009 at 5:15 pm

  #1054760

  "Hall of Fame"'s answer is 100% correct.