Post reply

How to move dts packages to new server?

  • May 17, 2005 at 4:46 pm

    #167034

    I am loading a new SQL 2000 server and want to move the DTS Packages From SQL 7 to this new server with different name. I can script the jobs and tables but don't know about the packages. Any help out there?

    Thanks

    Grant

  • May 18, 2005 at 1:06 am

    #559480

    It is possble if both server are on.

    open package in design mode. go in package and use save as option. There you give new server name, username & password. hope this will solve your problem

  • May 18, 2005 at 8:27 am

    #559590

    Hi

    Thanks I think that is what I will do. Else where you can save as as dts but I am not sure how open this file.

    thanks

    Grant

  • May 18, 2005 at 9:24 am

    #559623

    I use a freeware utilitiy called DTSBackup2000, discussed somwhere on this site.  It is very simple to use and works well for moving multiple DTS packages.   I am not certain that it works with both SQL Server 7 and SQL Server 2000, but I believe that it does.

    The download is available at

    http://www.sqldts.com/default.aspx?t=6&s=105&i=242&p=1&a=0

    Ken

  • May 18, 2005 at 9:57 am

    #559636

    If you want to move DTS packages to a brand new server, the easiest way is to backup the msdb database and restore it to the new server.

  • May 19, 2005 at 11:21 am

    #559941

    execute this query.

    INSERT INTO NEWSERVER.MSDB.DBO.SYSDTSPACKAGES

    SELECT * FROM OLDSERVER.MSDB.DBO.SYSDTSPACKAGES

     

    or export all records from msdb.dbo.sysdtspackages to new server.

     

    I am sure it will help.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply