Backing Up DTS packages

I am looking for a way to back up local DTS packages. Are they stored in
msdb? Has anyone dealt with the backup issue for DTS packages?
--
Larry Menzin
American Techsystems Corp.I save them out to disk as .dts file and store them in Visual Source Safe.
Greg Jackson
PDX, Oregon|||Hi,
All the DTS packages will be stored in MSDB. So backing up the MSDB database
will be enough.
See the below link for more info:-
http://www.databasejournal.com/features/mssql/article.php/1462601
Thanks
Hari
SQL Server MVP
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:75673569-040D-458F-B62D-1AB1EA76D285@.microsoft.com...
>I am looking for a way to back up local DTS packages. Are they stored in
> msdb? Has anyone dealt with the backup issue for DTS packages?
> --
> Larry Menzin
> American Techsystems Corp.|||Yes, packages are in msdb. So just make sure you have backup of your msdb database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:75673569-040D-458F-B62D-1AB1EA76D285@.microsoft.com...
>I am looking for a way to back up local DTS packages. Are they stored in
> msdb? Has anyone dealt with the backup issue for DTS packages?
> --
> Larry Menzin
> American Techsystems Corp.|||Also have a look at DTSBackup 2000
http://www.sqldts.com/default.aspx?242
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Larry Menzin" <LarryMenzin@.discussions.microsoft.com> wrote in message
news:75673569-040D-458F-B62D-1AB1EA76D285@.microsoft.com...
>I am looking for a way to back up local DTS packages. Are they stored in
> msdb? Has anyone dealt with the backup issue for DTS packages?
> --
> Larry Menzin
> American Techsystems Corp.