I deleted a dts package and need to restore it. I understand that the package
should be in the msdb table, but id not. We do backup the server to a tape
backup, but I do not know where the dts packages are stored. Is it in the
msbddata.mdf file? If so, if I retore just that file, is it enough and once I
retsore the file then what do I do? Any help would be appreciated. Thanks in
advance.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200602/1

Hello Jay via SQLMonster.com,

IF you save DTS packages to SQL Server Local Packages then they are stored
in msdb.dbo.sysdtspackages.

You can restore this DB to another name on your server and simply transfer
over the packages you require. have a look at this.

http://www.sqldts.com/default.aspx?204


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks for the response Allen, I do not see the particular package in the
table. I was able to find a copy of the package somewhere else. How do I make
sure that the dts package is being saved to the msdb table? Is there a
setting? Any advice would be appreciated.

Allan Mitchell wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200602/1

Hello Jay via SQLMonster.com,

There are 3/4 options in the File ¬ Save / Save As menu.

SQL Server is one of those but f you open the package from the file system
and simply hit "Save" then it will save back to the FS.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com