I have not saved it previously. Does it save in any
database that I can ask for restore?

Many thanks

Cheers,
Dan

If you have never saved the DTS package then it is in memory at that point
and that's that. DELETED suggests it was saved somewhere though.

DTS packages have a number of storage locations and you offer no details as
to where, if it was previously stored, you got your package.

The two most usual places are

In the filesystem with a .DTS extension
In MSDB (You can view these through the Data Transformation Services | Local
Packages in EM.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


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

Thanks Allen. Got my answer.