I was a bonehead and uninstalled MSDE 2000 which had a
fairly elaborate DTS Package.

Not realizing what had happened, I proceded to reinstall
MSDE 2000 and then of course noticed the package was gone.

Does SQL Server save a package anywhere on the hard drive
that is recoverable?

MSDE 2000 (DTS Package was created pre-SP3A.. the server
is now SP3A), running on Windows 2000 Pro.

Found my answer:

This option saves a DTS package in the sysdtspackages
table in the SQL Server msdb database as BLOB (binary
large object) data.

By default DTS packages are stored in MSDB unless you've told it to save
them elsewhere. Your options are File System, VB, Meta Data Services
(although this is MSDB)
Do you have a backup of MSDB?

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


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