Hi,
We appear to have lost all of our DTS packages from within
an SQL Server 7 database. There are no MSDB backups (ho
hum!). You can see the package names within "Local
Packages" but they appear to be empty. Can anyone tell me
where they are stored so that we can look and see if they
have just been disconnected in some way?

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

DTS packages are stored in the msdb.dbo.sysdtspackages table. The package
data is a blob, and not much good unless you use the object model to load
and examine it.
Perhaps you could check and older version of the package, or try ad
different machine to open the packages in case it is just the local EM that
cannot load or display it properly.


--
Darren Green
http://www.sqldts.com