February 23, 2007 at 8:50 am
Guys hi,
we have created a DTS package that runs as a scheduled job. The problem is that when i run it manually, the dts runs fine, but when i schedule it the job failed to run. I first thought that it had to do with permissions.
However, after reading packages log detail i found that it said that the step DTS_Step_DTSExecuteSQLTask_20 failed to run.
My problem is how to find this step? All steps in the package have been given names, and no step has the name in the form DTS_Step_DTSExecuteSQLTask_XX. How can i find what this step is?
Your help is appreciated, 🙂
DF
February 23, 2007 at 9:01 am
in your documentation ? I'm at a bit of a loss as I've never had problems isolating dts problems from the dts log - I first thought you needed logging enabled. chances are your problem is rights for the agent account which must have the same rights as you.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 23, 2007 at 9:08 am
I have constructed the DTS. And each step in the DTS has been given a name. eg, load_candidates, load_examinations, delete_fact_tables. The problem is that the error log on the DTS package, that shows me the step that has the error, does not say the name of the step, but sais the "original" name of the step, which i can not see.
For example when you create a step, it takes a name, remember? like of the form DTS_Execute_STEP_1. This name i changed to my desired name. Now the log says the package has got a mistake in this step, however this step does not exist. In fact, from the moment it was created, it was also renamed with an appropriate name. But the log uses the original name. The package runs every day, but the log does not say the names we have given, but the names SQL server gives, even though these names have long cease to exist.
February 23, 2007 at 9:14 am
to help you further the log created YESTERDAY (when the job failed to run) it said, Step name that failed was DTSStep_DTSExecuteSQL_Task_20.
But we have changed the step names, not yesterday, but much longer before. So why does it keep the original name?
how can i find which step sql server refers to, by this name?
February 23, 2007 at 3:09 pm
Right click on the DTS and select Disconnected Edit. Expand Steps and look for the name, in the Description Property you can see the name that is displayed by the DTS.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply