In sysdtspackages you will not see job information, you will see the
name of the packages and their versions. If you can see the package in
sysdtspackages then you still have the package. It is possible he
deleted a version of the package.
Allan
"jaylou" <jaylou (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi all,
A developer deleted one of his DTS packages from a DEV server.
Unfortunately we only backup DEV weekly and his creation and deletion
happened between Backups. I see the job name in sysdtspackages, and
there is
a column called packagedata.
Is there a way to restore the DTS package from this information?
TIA,
Joe |