Where are DTS's stored in SQL ?

[GJP55]

Can anybody tell me where DTS's are stored inside SQL. (ie. part of the Master database ? or Model database ? , etc).

 

[JohnDTampaBay]

Please do not cross-post. Check out your other thread: thread962-796681

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[ClaireHCM]

Angel:
I dont think you answer his question.The answer you provides is where you can refer in BOL and what are the format you could stored a DTS package.

To answer GJP55's question.

select * from msdb..sysdtspackages

 

[GJP55]

Thats great, thanks very much.