Simple DTS/trace question

[jaylou]

Hi All,
I have a trace setup to track all Admin events. This morning I noticed tht my SQL agant dropped and created a table thru a DTS package. Can anyone tell me what table holds the DTS package ID, and also what column in a trace file holds this ID?

Thanks,
Joe

 

[ter79]

If I'm understanding you question correctly, the system table that contains the DTS Package ID is sysdtspackagelog in the msdb database. As for the second part of your question, I don't have an answer.