How to remove obsolete Tasks

#1

Hi there,

We donâ€™t know how we ended up with more Tasks then Steps, but when we look in Disconnected Edit we see that that is the case. When we look closely in al the individual Steps we see that some Tasks are never connected to a Step. Is their a way to remove these obsolete Tasks?

Annick van den Broek

#2

Hi,

I am looking into this issue, please understand that I need some time to do
research on it. I promise to keep you updated ASAP.

It is highly appreciated if you could provided me a scenario, which, I
believe, will make me better understand yoru words

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!

Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

#3

You can remove tasks in code using the Remove method of Tasks
collection. The following snippet removes the first task in the collection:

dim oPkg
set oPkg = DTSGlobalVariables.Parent
oPkg.Tasks.Remove 1

Farid

Annick wrote:

Quote:

Hi there,

We donâ€™t know how we ended up with more Tasks then Steps, but when we look in Disconnected Edit we see that that is the case. When we look closely in al the individual Steps we see that some Tasks are never connected to a Step. Is their a way to remove these obsolete Tasks?

Annick van den Broek

#4

Hi,

I see that you use Disconnected Edit to reproduce the problem. I am afraid
that there is not a method to do through Enterprise Manager UI. You may try
Farid's programmatic method.

When we use Disconnected Edit feature, we need to be very careful. Books
Online has cautioned us.
Caution Because Disconnected Edit does not validate changes to property
values, entering invalid data can result in package failure and unwanted
effects on your system. Disconnected Edit is similar to Registry Editor.
Both are powerful tools for editing properties directly, and it is
recommended that both be used only by advanced users when there are no
alternative methods of modifying values.

Bill Cheng
Microsoft Online Partner Support
Get Secure! – www.microsoft.com/security
This posting is provided “as is” with no warranties and confers no rights.
--------------------

Quote:

Thread-Topic: How to remove obsolete Tasks
thread-index: AcRz+eQNrbPBmsJTTTuK0pGWx3JQtQ==
X-WBNR-Posting-Host: 212.241.41.253
From: =?Utf-8?B?QW5uaWNr?= <carel (AT) sfbgroep (DOT) nl
References: <7AB695C4-D744-488B-9DC8-97D65E9CEA64 (AT) microsoft (DOT) com
mTmwwRWcEHA.2924 (AT) cpmsftngxa06 (DOT) phx.gbl
Subject: RE: How to remove obsolete Tasks
Date: Tue, 27 Jul 2004 09:50:58 -0700
Lines: 14
Message-ID: <69DA9B5A-BE5B-473B-B97D-B0D8A2ECE239 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.dts:50077
X-Tomcat-NG: microsoft.public.sqlserver.dts

Hi,

I found how our package obtained more Tasks then Steps in Disconnected
Edit. What you do is:
1) Create a Task using the GUI
2) Using Disconnected Edit --> Steps --> DTSStep_DTSDataPumpTask_1 --
change the TaskName to a nonexistent Task
3) Delete the Task/Step using the GUI

Result: The Step is deleted but the Task still exists.

If I could connect 2 Tasks to 1 Step and then delete the Step using the
GUI, I could remove surplus Tasks. Is it possible to connect more then 1

Task to 1 Step?

Quote:

Thanks,
Annick van den Broek

#5

billchng (AT) online (DOT) microsoft.com ("Bill Cheng") wrote in message news:<0R61rpHdEHA.2416 (AT) cpmsftngxa10 (DOT) phx.gbl>...

Quote:

Hi,

I see that you use Disconnected Edit to reproduce the problem. I am afraid
that there is not a method to do through Enterprise Manager UI. You may try
Farid's programmatic method.

When we use Disconnected Edit feature, we need to be very careful. Books
Online has cautioned us.
Caution Because Disconnected Edit does not validate changes to property
values, entering invalid data can result in package failure and unwanted
effects on your system. Disconnected Edit is similar to Registry Editor.
Both are powerful tools for editing properties directly, and it is
recommended that both be used only by advanced users when there are no
alternative methods of modifying values.

If Microsoft would fix DTS we wouldn't wind up with phantom tasks and
connections in packages, and our need to use disconnected edit would
be decreased or eliminated. In particular, I find it extremely
irritating that anything beyond a simple select statement in a data
pump cannot be parsed by Designer, forcing me to depend on DE to get
it to work. There is a similar problem with getting Designer to
properly recognize paramenters.

DTS needs an interim release before Yukon, unless the real message is
that it is fundamentally unfixable.

JP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to remove obsolete Tasks

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

How to remove obsolete Tasks - 07-23-2004 , 05:21 AM

RE: How to remove obsolete Tasks - 07-24-2004 , 04:56 AM

Re: How to remove obsolete Tasks - 07-25-2004 , 10:31 PM

RE: How to remove obsolete Tasks - 07-28-2004 , 03:10 AM

Re: How to remove obsolete Tasks - 07-30-2004 , 01:57 PM