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.
    hakeem777, Feb 14, 2011
    #2

  2. satya Moderator

    satya, Feb 15, 2011
    #3

  3. hakeem777 New Member

    Thanks for the information. How do I use the profiler to do? Please advise me. CHeers
    hakeem777, Feb 15, 2011
    #4

  4. satya Moderator

    satya, Feb 15, 2011
    #5

Share This Page