SQL Server Performance

Script a DTS package

Discussion in 'SQL Server DTS-Related Questions' started by CanadaDBA, Oct 7, 2004.

  1. CanadaDBA New Member

    I am going to change a DTS package but I want to script current DTS to be able to recover it in case of an emergency. How can I script a DTS package?

  2. Luis Martin Moderator

    Far away from office, I remember that: Right click on job, script job.
    I don`t remember if that work for all jobs or individual.

    Luis Martin

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

  3. FrankKalis Moderator

  4. satya Moderator

  5. Luis Martin Moderator

  6. CanadaDBA New Member

    I went to a half an hour meeting and when came back I had 4 replies! Amazing! Thanks.

  7. CanadaDBA New Member

    A friend suggested right click on DTS and click on Versions. It seems SQL-Server maintains different versions of DTS package whenever it is saved. Having this feature, I can go back and reload previous DTS in case of an emergency.

  8. satya Moderator

    That helps if you can maintain(script) the DTS package on every modification affected.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page