SQL Server Performance Forum – Threads Archive

"fail package on step failure"

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? Regs,
MG

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

True as a start using PROFILER is better option. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Twain, there is no properties of objects in RTblDTSProps.
There is list of objects, but with no properties. Satya, PROFILER? How to use it? MG

It must be a related table then…. using profiler is a good way to find out which Profiler is a tool on your start menu in the SQL Server group. Create a new trace connect to your server 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 click ok now take a look at the property you’re interested in through EM, and come back to Profiler to see what EM does Cheers Twan

Thanks,
MG

]]>