my job taht executes dts failed and error says something like
DTSRun OnError: DTSStep_DTSExecuteSQLTask_6, Error ...
all my sql task steps are named, so how do know which step is step DTSStep_DTSExecuteSQLTask_6?
The DTS itself has 50 diff sql tasks created and added at diff times.
I could not find anything in msdb dts tables