SQL Server Performance

Copy or Move DTS Packages

Discussion in 'SQL Server DTS-Related Questions' started by EasySQL, Mar 8, 2006.

  1. EasySQL New Member

    I had a question on how to move or copy a DTS package from one db to another one.
    Thanks
    EasySQL, Mar 8, 2006
    #2

  2. ranjitjain New Member

    If you wanna copy DTS from one server to another in the same network then
    open DTS in designer open save as dialogue box and enter the server details and click save to save it on another server.

    If another server is in diffrent network then read about structured storage file in BOL.
    Save DTS in file format and send it to another server then open that file on serverB and then save it.
    ranjitjain, Mar 8, 2006
    #2

  3. satya Moderator

    The best option is to backup MSDB and restore it on target server, thsi way you're easily managing all scheduled jobs.

    Refer tohttp://www.sqldts.com/default.aspx?204 for relevant information.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 9, 2006
    #2

  4. EasySQL New Member

    Hi Satya
    But would this not overwrite the existing MSDB and hence overwrite the existing jobs and packages.
    Thanks i will take a look at the link u have posted.
    EasySQL, Apr 5, 2006
    #2

  5. Luis Martin Moderator

    Other option is to work with sysdtspackages, is msdb table.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Apr 5, 2006
    #2

  6. satya Moderator

    I will not incline towards loading a system table using DTS, otherwise refer to the link above.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Apr 6, 2006
    #2

  7. cmdr_skywalker New Member

    Use a VB script to save the DTS packages to a file (as ranjitjain mentioned) and load it (using another VBScript) into your destination server.

    May the Almighty God bless us all!
    www.empoweredinformation.com
    cmdr_skywalker, Apr 27, 2006
    #2

Share This Page