SQL Server Performance

copying DTS from one server to another

Discussion in 'SQL Server DTS-Related Questions' started by korzon, Feb 19, 2004.

  1. korzon New Member

    Hi,

    We're migrating to a newer SQL server tonight and I was wondering if there's an easy way to copy Data Transformation Services from the old SQL server to the new one. We have quite a few of them so saving each one individually and then rebuilding it is going to be quite an annoyance.

    Thank you.
  2. satya Moderator

  3. korzon New Member

    Thanks,

    That did the trick!
  4. satya Moderator

    Lately, to advise on keep in touch with that website for DTS goodies.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page