I am using SQL Server 2000.

If I can see a DTS package under Data Transformation Services/Local
Packages,

that means the package is saved in SQL Server.

If I take master database backup, in case of disaster I can recover the
master database and all these DTS packages are restored.

Is it correct?

Wilson

In article <uzX0GsoaEHA.2792 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, WilsonSmith wrote:
Nope.

Packages are stored, when saved to SQL Server, in MSDB.



Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

My ultimate goal is to make sure all the DTS package that I can see in the
SQL Server Enterprise Manager Data Transformation Services/Local
Packages are backed up properly.
How to ensure that ?
Wilson


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

You make sure you backup MSDB


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Thanks.


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

Allan,
Here is my question
" If I can see a DTS package under Data Transformation Services/Local
Packages, that means that DTS package is saved in SQL Server."
Is it correct?
Wilson



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

In article <uILsapraEHA.4092 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, WilsonSmith wrote:
You are correct


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs