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.


  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
    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