Copy SQL Server Objects from SQL 2000 to SQL 2008 using DTS 2000

• kpyap001

  Valued Member

  Points: 60

  More actions

  February 19, 2009 at 7:39 am

  #103689

  Hi All,

  I have recently upgrade one of my SQL server to 2008

  When I run SQL 2000 DTS Package using Copy SQL Server Objects from SQL 2000 to SQL 2008, it prompt error:

  Microsoft SQL-DMO (ODBC - SQLState: 42000)

  [Microsoft][ODBC SQL Server Driver][SQL Server] To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)

  Any idea to resolve this error?

  Thank you in advance

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  February 19, 2009 at 4:24 pm

  #947255

  I believe that you will have to migrate your package from SQL 2000 to at least SQL2005 before it will work.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]