When executing a DTS package under SQL server 2000, for each step certain
information is made available upon completion of each step. There are the
following columns:

1) Status
2) Start Time
3) Finish Time
4) Execution time

What would be the easiest way to trap this information and be able to do
something with it (say if you execute the task through an ActiveX script
where you can enumerate through the steps). I am specifically interested in
the Status column.

Appreciate any helpful tips you may have.


Thanks,
Leo