|
Home > Archive > MS SQL Server DTS > July 2005 > Disconnected Edit and renaming tasks
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Disconnected Edit and renaming tasks
|
|
|
| The only way I have found to rename tasks via the interface is the
Disconnected Edit, unfortunately when I try to edit the task I get the
following error:
---------------------------
Package Error
---------------------------
Error Source : Microsoft Data Transformation Services (DTS) Package
Error Description : Task 'DTSTask_DTSDataPump
Task_1' was not found.
---------------------------
OK
---------------------------
How can I rename a task without causing this problem ?
| |
| Bill Swartz 2005-07-19, 8:24 pm |
| You cannot rename a task once you have the workflow in place. You have to
disconnect the workflow then reconnect it after the rename. Also, be sure
to rename both the task and the step. (I'm not sure that last part is
required, but it worked for me)..
Bill
"GMG" <nospam@nospam.com> wrote in message
news:u8E8NILjFHA.3300@TK2MSFTNGP15.phx.gbl...
> The only way I have found to rename tasks via the interface is the
> Disconnected Edit, unfortunately when I try to edit the task I get the
> following error:
>
> ---------------------------
> Package Error
> ---------------------------
> Error Source : Microsoft Data Transformation Services (DTS) Package
>
> Error Description : Task 'DTSTask_DTSDataPump
Task_1' was not found.
>
> ---------------------------
> OK
> ---------------------------
>
>
> How can I rename a task without causing this problem ?
>
>
| |
| Darren Green 2005-07-20, 8:24 pm |
| In message <u4qk1iLjFHA.3144@TK2MSFTNGP12.phx.gbl>, Bill Swartz
<wsaharem@yahoo.com> writes
>You cannot rename a task once you have the workflow in place. You have to
>disconnect the workflow then reconnect it after the rename. Also, be sure
>to rename both the task and the step. (I'm not sure that last part is
>required, but it worked for me)..
>
>Bill
Actually you can if you know what you are doing, but workflow just makes
it harder, and it is easy enough to delete, rename, then add back.
I suggest you try these steps-
Expand Task (DTSTask_MyTask1), and change Name property
(DTSTask_MyTaskNiceN
ame).
Expand Step (DTSStep_MyTask1), and change TaskName property to match
(DTSTask_MyTaskNiceN
ame).
Change Step Name as well to match, (DTSStep_MyTaskNiceN
ame).
If you still have workflow leading from that step (the step is the
preceding step for the constraint), then you now need to fine the step
that is leads to (the constrained step). Expand the constrains
collection and find the one with the StepName which now needs updating
to match above.
The Step name is probably all you need to change (and of course
workflow) as that is what you see in the log, not the Task name.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
|
|
|
|
|