Hi All
is there a way to trace the DTS package. We use profiler to profile/trace
the sql database. but is there a way to trace the dts package, each step of
it.
We have active x script and i need to trace thru each step as it executes.

thanks in advance

Unfortunately not in this release.

You will have to MsgBox out what you need to know

You could also use the DTSPackageLog.WriteSringToLog

Allan



"Nik" <patelnikhil30 (AT) hotmail (DOT) com> wrote

If my memory serves me correctly, I had a coworker enable the JIT debugger
on a finiky package. I believe it is only called during an error event and
the debugging is somewhat limited.

I personally, never had a need to do this, I usually find that using MsgBox
works just fine for me.

-Mike Gercevich

--
Message posted via http://www.sqlmonster.com