Upgrading DTS packages to a separate server

• lhughes92

  SSC Enthusiast

  Points: 146

  More actions

  October 31, 2003 at 8:08 am

  #106541

  I have an existing SQL Server 7.0 and will be upgrading to SQL Server 2000 on a different box. I need to get the packages from 7.0 to 2000 without having to open each one manually and save as a text file or save as to the other server. I have created a Linked Server on the 7.0 box and issued the following query:

  insert into sql7server.msdb.dbo.sysdtspackages

  (name, id, versionid, description, categoryid, createdate, owner, packagedata, owner_sid)

  select name, id, versionid, description, categoryid, createdate, owner, packagedata, owner_sid from sql2k.msdb.dbo.sysdtspackages

  The records were added successfully and I can see the package in Enterprise Manager.

  Does anyone know of any issues of doing this?

  Thank you,

  Lori Clark

• November 3, 2003 at 8:00 am

  This was removed by the editor as SPAM

• philcart

  SSC-Forever

  Points: 47796

  More actions

  November 4, 2003 at 3:48 pm

  #480821

  If your service packs are up-to-date, then there shouldn't be any problems. There were some changes to the object model between the service packs.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface