Re: Restoring individual DTS Packages

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 06:33:24 +0100

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@nomail.please> wrote in message
news:3jgqb0hlpb5mu3dt7l2vdmtj7seqd5lmtn@4ax.com...
> 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@discussions.microsoft.com> wrote:
>
> >Is there a known way of restoring individual DTS packages
> >from backup?
> >
> >Thanx for your help,
>