dbTalk Databases Forums  

Disconnected Edit and renaming tasks

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Disconnected Edit and renaming tasks in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GMG
 
Posts: n/a

Default Disconnected Edit and renaming tasks - 07-19-2005 , 05:32 PM






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_DTSDataPumpTask_1' was not found.

---------------------------
OK
---------------------------


How can I rename a task without causing this problem ?



Reply With Quote
  #2  
Old   
Bill Swartz
 
Posts: n/a

Default Re: Disconnected Edit and renaming tasks - 07-19-2005 , 06:22 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 (AT) nospam (DOT) com> wrote

Quote:
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_DTSDataPumpTask_1' was not found.

---------------------------
OK
---------------------------


How can I rename a task without causing this problem ?





Reply With Quote
  #3  
Old   
Darren Green
 
Posts: n/a

Default Re: Disconnected Edit and renaming tasks - 07-20-2005 , 02:56 PM



In message <u4qk1iLjFHA.3144 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Bill Swartz
<wsaharem (AT) yahoo (DOT) com> writes
Quote:
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_MyTaskNiceName).

Expand Step (DTSStep_MyTask1), and change TaskName property to match
(DTSTask_MyTaskNiceName).

Change Step Name as well to match, (DTSStep_MyTaskNiceName).

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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.