I've got the msdbdata.mdf and msdbdata.ldf files for a server that once had a
DTS job that I'm trying to recover. The package was never saved (ugh), and
the sysdtspackages table is empty, indicating that this msdb db doesn't have
the package. However, I see remnants of the package in other tables (I
think). Particularly in the UMLOperation table, there are rows containing
TSQL, VBScript, etc. from this package.
Is there any way to recover this package, even if there isn't any
information in the sysdtspackages table? Can anyone tell me anything about
the UMLOperation table?
Thanks!
Chris