SQL Server Performance

"fail package on step failure"

Discussion in 'SQL Server DTS-Related Questions' started by mirek.grodzki, Sep 25, 2003.

  1. mirek.grodzki New Member

    I'm looking way to find which objects in my DTS packages are
    with properties "fail package on step failure".
    (I mean some sql query to execute to find it)

    I should be written in some table in msdb base. I'm I right?

  2. Twan New Member

    yep probably something like RTblDTSProps, not sure if anyone has documentation on these though. Something which can be useful is to start profiler capturing all sql, and then use Enterprise Manager to open a DTS package and/or change the property value. The Profiler trace should give you some idea as to what table(s) to look at

  3. satya Moderator

    True as a start using PROFILER is better option.

    Satya SKJ
  4. mirek.grodzki New Member

    Twain, there is no properties of objects in RTblDTSProps.
    There is list of objects, but with no properties.

    Satya, PROFILER? How to use it?

  5. Twan New Member

    It must be a related table then.... using profiler is a good way to find out which<br /><br />Profiler is a tool on your start menu in the SQL Server group.<br /><br />Create a new trace<br />connect to your server<br /><br />monitor events SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tarting, SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtStarting, Batch<img src='/community/emoticons/emotion-7.gif' alt=':S' />tarting, Batch<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtStarting<br /><br />click ok<br /><br />now take a look at the property you're interested in through EM, and come back to Profiler to see what EM does<br /><br />Cheers<br />Twan
  6. mirek.grodzki New Member

Share This Page