How to disable a precedence contstraint

#1

In my DTS package there are two possible execution paths. They both finish
with a common "end" task. I am able to execute the desired path by disabling
the steps of the path I do not want to execute. However, the "end" task does
not get executed.

The last task in both paths have a constraint that points to the "end" task.
I need to be able to delete the constraint of the path not chosen. Is there
an easy way to do this?

Thanks!

Ric

#2

Hello Ric,

Sounds as though this article will help

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

Allan

Quote:

In my DTS package there are two possible execution paths. They both
finish with a common "end" task. I am able to execute the desired
path by disabling the steps of the path I do not want to execute.
However, the "end" task does not get executed.

The last task in both paths have a constraint that points to the "end"
task.
I need to be able to delete the constraint of the path not chosen.
Is there
an easy way to do this?
Thanks!

Ric

#3

Hi Allan, I actually read that article this morning (I usually check
sqldts.com as a first step). However, it seemed like a lot of code for
something so simple. I was hoping that there might be a simpler way to
disable a constraint.

Ric

"Allan Mitchell" wrote:

Quote:

Hello Ric,

Sounds as though this article will help

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

Allan

In my DTS package there are two possible execution paths. They both
finish with a common "end" task. I am able to execute the desired
path by disabling the steps of the path I do not want to execute.
However, the "end" task does not get executed.

The last task in both paths have a constraint that points to the "end"
task.
I need to be able to delete the constraint of the path not chosen.
Is there
an easy way to do this?
Thanks!

Ric

#4

Hello Ric,

Unfortunately not

Quote:

Hi Allan, I actually read that article this morning (I usually check
sqldts.com as a first step). However, it seemed like a lot of code
for something so simple. I was hoping that there might be a simpler
way to disable a constraint.

Ric

"Allan Mitchell" wrote:

Hello Ric,

Sounds as though this article will help

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)
Allan

In my DTS package there are two possible execution paths. They both
finish with a common "end" task. I am able to execute the desired
path by disabling the steps of the path I do not want to execute.
However, the "end" task does not get executed.

The last task in both paths have a constraint that points to the
"end"
task.
I need to be able to delete the constraint of the path not chosen.
Is there
an easy way to do this?
Thanks!
Ric

#5

Thanks for your help, Allan, I appreciate it.

Ric

"Allan Mitchell" wrote:

Quote:

Hello Ric,

Unfortunately not

Hi Allan, I actually read that article this morning (I usually check
sqldts.com as a first step). However, it seemed like a lot of code
for something so simple. I was hoping that there might be a simpler
way to disable a constraint.

Ric

"Allan Mitchell" wrote:

Hello Ric,

Sounds as though this article will help

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)
Allan

In my DTS package there are two possible execution paths. They both
finish with a common "end" task. I am able to execute the desired
path by disabling the steps of the path I do not want to execute.
However, the "end" task does not get executed.

The last task in both paths have a constraint that points to the
"end"
task.
I need to be able to delete the constraint of the path not chosen.
Is there
an easy way to do this?
Thanks!
Ric

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

How to disable a precedence contstraint

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

How to disable a precedence contstraint - 05-15-2006 , 10:32 AM

Re: How to disable a precedence contstraint - 05-15-2006 , 12:54 PM

Re: How to disable a precedence contstraint - 05-15-2006 , 01:04 PM

Re: How to disable a precedence contstraint - 05-15-2006 , 01:29 PM

Re: How to disable a precedence contstraint - 05-16-2006 , 09:13 AM