I am fairly new to using DTS packages and I have Package logs enabled in my
DTS package which has a lot of "Execute SQL Tasks". When one of these tasks
fail it shows up in the error log, but the step name would as generic as
"DTSStep_ExecuteSQLTask_23" and sometimes its difficult for me to track down
which task failed. I tried to figure out a way to map this step name to task
but I couldnt. So, my questions is,is there a way to get this information
from a table in master db(or elsewhere, if its not stored in master db) or
another tool that I could use to figure this out.

Thanks,
-Dinakar.

There is nothing outside of the package that would tell you this. It is
possible to change these names using Disconnected edit but this should not
really be attempted after you have built a package as you are guaranteed to
miss something and your package will no longer work.

Each step has a TaskName property so you could use some code to loop this up
although even armed with the TaskName it may be equally as cryptic. You
might want to look at the Description property though.

Allan



"D" <D (AT) discussions (DOT) microsoft.com> wrote

Allan Mitchell wrote:
Not too big a deal, I think. If you delete the workflow constraints it
is easy to rename the step through Disco Edit. The workflow is what
trips people up. Note, deleting the constraints does not loose any
workflow scripts, so it is quite easy.

Rename the step, and you may also want to rename the task, but then do
the TaskName property on the step as well.

I do three properties-

Task Object
- Name property


Step Object
- Name property
- TaskName property (Relates step to task, so match to Task.Name as above)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com