Is there a known way of restoring individual DTS packages
from backup?

Thanx for your help,

As in packages that have been deleted? In general, there is
no way to restore individual objects from a backup. You'd
need to restore database (msdb for packages) to another
server and get the packages from there.
If the packages still exist on the server and you need a
previous version, you can right click on a package, select
versions. You can select a previous version and click on the
edit button. Then save the package for this to become the
current running version of the package.

-Sue

On Tue, 1 Jun 2004 17:23:30 -0700, "Raoul Laoyan"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

In addition to Sue's comments.

If I knew I was going to want to restore individual packages every time then
maybe MSDB is not the place to be storing your packages (or maybe you should
use two places). As Sue says MSDB as a whole will need to be restored. How
about saving packages out to structured storage files as well as in MSDB.
This makes them slightly more portable.
If you want to have them backed up as a SQL Server backup then how about
creating a database with one table and that will be a replica of
sysdtspackages? This way it will be a lot quicker to restore as a whole
than maybe MSDB as there will be none of your job stuff in there etc

Just a couple of ideas.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

Could run DTS Backup, either manually or scheduled. Makes it easy to restore
a package too.

DTSBackup 2000
(http://www.sqldts.com/default.aspx?242)

Darren

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote