hello,


i have restore the old database of a server and i'm
looking for all the information's of the old dts.
Could you explain me where can i find the informations.
I have already find the name and description of the dts
(in the database msdb in the table "sysdtspackages") but
i can't find the differents step of the DTS.



Thanks in advance for any advice.

Regards
Pierre-Yves

You won't find them in a table. It is all stored in the packagedata column
of the sysdtspackages table.

You can use the DTS object model to enumerate through your steps in a
package or you can simply open the package up.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"pierre-yves" <pierreyves (AT) digitallife (DOT) be> wrote