"Joe Gass" wrote:

> Hi,
> we have DTS packages which call other DTS packages, sometimes a few levels
> deep.
> In our error logs out DTS steps are labelled like
> "DTSStep_DTSExecutePackageTask_4"
> Is there a way to give our DTS steps custom labels so that it'll be easier
> to work out which dts and which step has failed?
> Server 2K
> Thanks
>
>
>

"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:324ED758-4CC5-4DB1-A01A-D041548013CD@microsoft.com...
> Yes you can, and should do this...
>
> Open your package and right click in the white space, go to Disconnected
> Edit... There you can change the names of the Tasks and Steps.... Be
> careful
> tho,,, Change the Task name, then you have to go to the step which calls
> the
> task, and change the taskname there to match... While there, you can also
> change the Step name...
>
> Save a copy before messing with this... It's easy to mess up..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
>
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
>
> "Joe Gass" wrote:
>
>> Hi,
>> we have DTS packages which call other DTS packages, sometimes a few
>> levels
>> deep.
>> In our error logs out DTS steps are labelled like
>> "DTSStep_DTSExecutePackageTask_4"
>> Is there a way to give our DTS steps custom labels so that it'll be
>> easier
>> to work out which dts and which step has failed?
>> Server 2K
>> Thanks
>>
>>
>>