woensdag, april 01, 2009

MS SQL: DTS step names and numbers


You've got yourself a DTS package in SQL 2000. You get an error message in a log file stating something like 'DTSStep_DTSExecutePackageTask' and 'DTSStep_DTSExecuteSQLTask' and some numbers. Now you need to figure out which numbers in the error message correspond to the steps in your DTS?! I found myself looking around for quite some time before figuring this out. The solution was found in KB-article 81526. In short: open your DTS-package, in the menu click Package, and there select 'Disconnected Edit' (why didn't i think of that before; it's such an obvious name ;-)). Now you can select tasks and steps, and in the properties pane of the task or step you see more info, like task names etc.

2 opmerkingen:

  1. Anoniem12:45 p.m.

    Great, didnt realise how hidden te tasks name were. Thank you

    BeantwoordenVerwijderen
  2. Anoniem3:19 p.m.

    Thinking .. why I haven't seen so far.
    Any way thanks... I just had a need.
    Rajdip

    BeantwoordenVerwijderen