SQL Server Performance

dts job

Discussion in 'General DBA Questions' started by v1rtu0s1ty, Nov 6, 2004.

  1. v1rtu0s1ty New Member

    hey guys,

    I would like to know how I can extract the information of a compiled code being ran by a dts job. Is there a way to find out what the code is or what it does? The vendor doesn't like to share it to us.

    Thanks,

    V1rt
  2. satya Moderator

    Other than using PROFILER I don't think its possible to extract the code and I'm not entirely sure about using PROFILER will give you chance.#

    If you can access the server then try to view the DTS job which is scheduled.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. v1rtu0s1ty New Member

    Thanks again Satya! <img src='/community/emoticons/emotion-5.gif' alt=';)' />

Share This Page