• This is a great article on DTS Auditing indeed.

    I was just wondering if you could use the same approach to audit the actual execution of all DTS packages instead of capturing the changes made to them. That is logging the execution of all DTS packages using a trigger on the systable? What sys tablee/fields can be used?

    This will greatly help DBA/Developer finding out which DTS packages are bieng called/used.

    I would greatly appreciate your input on this

    Thank you

    Tim