We've got a warehouse of data that is generated with
DTS. The database is SQL Server 2000 with the latest
service packs on top of Windows 2000.

What needs to be done to backup the DTS packages?

mentioned that backing up the msdb database where the DTS
packages are stored is adequate backup.

Have a look at these articles they should help


Backing Up Packages
(http://www.sqldts.com/default.aspx?202)

DTSBackup 2000
(http://www.sqldts.com/default.aspx?242)

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jim" <anonymous (AT) discussions (DOT) microsoft.com> wrote