Hi guys,
I got a question, how to backup dts package. Because the backup database
doesn't include dts package, is there any way that we can use to backup dts
package.
Thanks.

Have a look here:
http://www.sqldts.com/default.aspx?242


--
Andrew J. Kelly SQL MVP


"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

There is a simply anwser (more than install a program)


The packages are stored in msdb database, in sysdtspackages tables.
However, you must have permissions to read this table.

So, you can create a table with the same structure than sysdtspackages
and then you can export by a DTS to this user table. after that you can
export to another server, but, please never, I said NEVER, alter the
data from de system table. Any modification of this system table can
generate a lost of data or lost of the DTS that are stored in the
database. (I can explain you by a personal experience... I lost every
packages from a server)

Another easy (and safe) way to backup this is backuping the msdb. (easy
and clean)

good luck.



Andrew J. Kelly ha escrito:

Hello Jx!,

and we detail this here

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


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