SQL Server Performance

Urgent: dts packages

Discussion in 'SQL Server DTS-Related Questions' started by hakeem777, Feb 14, 2011.

  1. hakeem777 New Member

    I have 100+ packages running in SQL2000 server and this packages are developed by someone else. Now I want to quickly retrieve information on
    which packages run on a certain database and a certain table. Just wonder if the packagedata field in sysdtspackages contain these information.
    But I realize this field is not readable. How can I view it? If it doesn't contain information I need, how can I retrieve these information quick
    instead of going to check manually one by one?
    Please adivse me. Thanks.
  2. satya Moderator

  3. hakeem777 New Member

    Thanks for the information. How do I use the profiler to do? Please advise me. CHeers
  4. satya Moderator

Share This Page