Results 1 to 2 of 2

Thread: auditing DTS

  1. 08-18-2003, 03:03 PM #1
    alex
    alex is offline Registered User
    Join Date
    Sep 2002
    Posts
    159

    auditing DTS

    how to audit DTS ?
    80 % of DTS run from
    exec master..xp_cmdshell 'dtsrun ....

    20 % started by server agent

    I have list with 200 DTS
    I want to delete dts that are not in use.
    Can I use profiler or it its possible to get info from system tables?

    Thank you
    Reply With Quote Reply With Quote
  2. 08-18-2003, 03:09 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You could run a profiler trace with a filter for DTSRUN and capture the data for few days to get a list of active DTS Packages.

    For unused ones rename them and keep them in the server for some more time, if nobody complains you can archive them and delete them.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules