Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
naming DTS package tasks
- Thread starter PJSWEAT
- Start date
I presume you are on SQL 2000 and you are using Disconnected Edit to rename the tasks.
The problem is that the steps refer to the tasks by name. So you have to go into the properties of each step and change the task to which it points for execution.
There may be other places where you need to do it. For me it was simply too much of a hassle for existing packages. If this is a new package it may be worth it to change the names, and you will probably want to rename the steps too.
DL
MCDBA, MCSD, MCT, etc.
The problem is that the steps refer to the tasks by name. So you have to go into the properties of each step and change the task to which it points for execution.
There may be other places where you need to do it. For me it was simply too much of a hassle for existing packages. If this is a new package it may be worth it to change the names, and you will probably want to rename the steps too.
DL
MCDBA, MCSD, MCT, etc.
gashandler
MIS
I found this thread because I didn't like the default task names assigned. I tried it out in the disconnected edit and unless it's a small pkg I don't think it's worth it at all. Like the previous poster said it looks like you have to change it in more than one place so it's a lot of work.
- Status
Similar threads
- Locked
- Question
- Locked
- Question