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 strongm 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

Status
Not open for further replies.

PJSWEAT

Programmer
Feb 3, 2003
82
US

I am trying to name my DTS package tasks but when I rename them and try to execute them they do not work, can anybody help?
 
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.
 
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
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top