Is there a good DTS debugger? I'm only using MsgBox's...

[jw970170]

I'm writting a fairly complex DTS that takes data from one place and spreads it out to a bunch of other places. It is basically just one activeX script task. The problem is that I can only debug by placing message boxes in various locations and seeing if the script executes to that point. No error code is even returned if it messes up. Is there a better way debugging?

 

[DrSql]

I execute one componet at a time, so that way I can see where it errorer out. Or you can create a table and inserst a statemnt "Sucessfully completed" if the setp executed sucessfully.

Dr.Sql
Good Luck.