SQL Server Performance

Saving DTS package

Discussion in 'SQL Server DTS-Related Questions' started by suneelmehra, Aug 29, 2006.

  1. suneelmehra New Member

    I have more than 100 DTS packages in one of my server. I want to copy all the DTA packages from one server to other.
    Is there any way to save all the DTS packages as a text file in one time. Saving individual package is very painful.

    Please advise.
  2. patel_mayur New Member

    quote:Originally posted by suneelmehra

    I have more than 100 DTS packages in one of my server. I want to copy all the DTA packages from one server to other.
    Is there any way to save all the DTS packages as a text file in one time. Saving individual package is very painful.

    Please advise.

    Please search on the site. It has been discussed many times. You just need to transfer your msdb..dtspackages table from source to destination server.



    Knowledge is not Power !!!
    But When its acted upon then its Power !!!
  3. suneelmehra New Member

    No, I can't over write the msdb database.
  4. satya Moderator

    That is the only way to achieve the task in easy way to restore msdb database, if not you have to save them as a file and use on destination server. As referred search on forum for any clues.

    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.

Share This Page