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.