I am trying to find a way to set a trigger on sys tables to log a record in my audit table every time a DTS package executes whether manually or through a job scheduler. I have been looking at these sys tables, but could not find which fields actually record the DTS package execution info.. sysdtspackage, sysdtspackaglog, sysdtspackageStep
and sysdtspackageTask
I know you could set a trigger on sysdtspackage table and get the information from sysprocess table to log changes to existing DTS packages and every time a package is created.
I am interested in finding out when a DTS packages runs.?
I could add a SQL task inside each DTS package but that would tedious with more than 400 of them.
I will appreciate any input.
Thank you
and sysdtspackageTask
I know you could set a trigger on sysdtspackage table and get the information from sysprocess table to log changes to existing DTS packages and every time a package is created.
I am interested in finding out when a DTS packages runs.?
I could add a SQL task inside each DTS package but that would tedious with more than 400 of them.
I will appreciate any input.
Thank you