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.
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.
Abonneren op:
Reacties posten (Atom)
Great, didnt realise how hidden te tasks name were. Thank you
BeantwoordenVerwijderenThinking .. why I haven't seen so far.
BeantwoordenVerwijderenAny way thanks... I just had a need.
Rajdip