October 6, 2008 at 9:41 am
Hi
I have a big DTS package (sounds rude) with 50 odd steps which takes 20 hours to run. I have been asked to make it quicker. If I look in the Package log 5 of the steps take up 15 hours but stepname = DTSStep-DTSExecuteDQLtask_** means nothing to me, how can I relate it to the names of the steps in the work flow diagram?
Many Thanks
October 6, 2008 at 10:12 am
Open the package in DTS Designer and click on "Disconnected Edit" under the Package menu. Expand Steps, highlight the one you're interested in and you'll see the details of the step and the task it's related to. If you gave the task a name or description, you'll see that listed so you can find it when you go back to the design pane.
Greg
October 7, 2008 at 4:47 am
Thank you so much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply