Trace DTS -- sql server dts

Allan Mitchell
5/25/2005 12:00:00 AM

Unfortunately not in this release.

You will have to MsgBox out what you need to know

You could also use the DTSPackageLog.WriteSringToLog

Allan

[quoted text, click to view]

Nik
5/25/2005 2:54:15 PM

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

Mike Gercevich via SQLMonster.com
5/28/2005 12:00:00 AM

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

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Trace DTS