Post reply

changing DTS StepName logging

  • November 14, 2002 at 1:31 am

    #158380

    I Wonder if somebody can help on this : I'm using logging of our DTS-Packages (both to msdb and to an ASCII-File). Unfortunately, the logging of the steps are created as (example) : "Step 'DTSStep_DTSDataPumpTask_1' succeeded" . I would like to have the "StepName Description" in the logging instead of the "StepName" . Does somebody has a solution for this ? Thanks for the help.

  • November 14, 2002 at 4:55 am

    #441336

    Open your DTS Package in EM. Then double click each item in the package, they all have description fields, this is where that comes from. Also, if you have any transformations double click the transformation line and give it a description.

  • November 14, 2002 at 5:30 am

    #441340

    Thanks for your answer but all our Descriptions ARE customized. The trouble is that DTS logs the StepName (which is a name as "'DTSStep_DTSDataPumpTask_1" and not the "Customized" Description.

  • November 14, 2002 at 6:04 am

    #441343

    See what you mean now. Looks like an incomplete feature. I find no way to get the details either.

  • November 19, 2002 at 7:15 pm

    #441787

    You can modify the Step name via Disconnected Edit. Be careful, you can screw things up if you forget to change one property. eg: The task name is also a property of the Step so you have to change it in both places.

    Myself, I implemented logging tables in the application database and extracted the information I needed from the MSDB tables.

    Here's a script I wrote to extract Error code and Description,

    http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=556

    Thanks

    Phill Carter

    Edited by - phillcart on 11/19/2002 7:18:22 PM

    --------------------
    Colt 45 - the original point and click interface

  • November 20, 2002 at 2:13 am

    #441800

    Many thanks for your hint about the "Disconnected Edit". I tried it and this will help us a lot. I'll also take a look at the script.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply