I have several instances of SQL Server 2000 and each has a large number of
DTS packages. I need to catalog the details of each DTS package
(description, connections, SQL statements, account used and so on). Opening
the properties of each package and copying out all of the information from
each package by hand would be a daunting and highly time-consuming task.

Is there a way to query the server to get all of the information on each DTS
package?

Thanks in advance,
Moishe