Backup DTS

  • I have SQL Server2000 and I need backup all DTS. I don't know how can I do?

    Please help me!!

    Thanks

  • DTS packages are stored in the msdb.dbo.sysdtspackages table.

    All you need is to backup that table.

    As an alternative you can save DTS as files, but you have to do it manually.

    For more info about DTS check http://www.sqldts.com, it contains also an utility to make a backup copy of all packages, try it

Viewing 2 posts - 1 through 1 (of 1 total)

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