Mark Forums Read

DTS workflow failure

Go Back

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

Reply

#1

Old

Microlong

Posts: n/a

DTS workflow failure - 02-22-2005 , 11:59 PM

I create a package to call other packages in one workflow ,it's very similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it runs on
failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure. Is there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

#2

Old

Allan Mitchell

Posts: n/a

Re: DTS workflow failure - 02-23-2005 , 12:28 AM

Are you looking for something like

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

"Microlong" <Microlong (AT) email (DOT) com> wrote

Quote:

I create a package to call other packages in one workflow ,it's very
similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it runs on

failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure. Is
there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

#3

Old

Microlong

Posts: n/a

Re: DTS workflow failure - 02-23-2005 , 12:33 AM

No, I don't know the reason why the step4won't run when step2 failed ? Do
you have experience on this case ?

"Allan Mitchell" wrote:

Quote:

Are you looking for something like

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

"Microlong" <Microlong (AT) email (DOT) com> wrote in message
news:Microlong (AT) email (DOT) com:
I create a package to call other packages in one workflow ,it's very
similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it runs on

failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure. Is
there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

#4

Old

Allan Mitchell

Posts: n/a

Re: DTS workflow failure - 02-23-2005 , 12:46 AM

Yes step 4 will not run because of a failure on Step 2 because it has no
idea about step 2 or rather it never gets told to wake up and look
around.

Step 3 should not execute if 2 fails either because you use an ON
SUCCESS constraint and it did not succeed.

You will either have to add an ON ERROR constraint + step to every work
step you do or get sexy by skipping steps but that could be more trouble
than it's worth.

Allan

"Microlong" <Microlong (AT) email (DOT) com> wrote

Quote:

No, I don't know the reason why the step4won't run when step2 failed ? Do

you have experience on this case ?

"Allan Mitchell" wrote:

Are you looking for something like

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

"Microlong" <Microlong (AT) email (DOT) com> wrote in message
news:Microlong (AT) email (DOT) com:
I create a package to call other packages in one workflow ,it's very
similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it
runs on

failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure.
Is
there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

#5

Old

Microlong

Posts: n/a

Re: DTS workflow failure - 02-23-2005 , 01:19 AM

I use simple links, on success and on failure are used in my case, and I set
"fail package on first error" is true. Do you mean that I should do other
things to wake up step4 when step3 fails. Does it a on failsure links to be
used between them ?
if so, what do I add the condition on this link between step2 and step4 ?
thanks !

"Allan Mitchell" wrote:

Quote:

Yes step 4 will not run because of a failure on Step 2 because it has no
idea about step 2 or rather it never gets told to wake up and look
around.

Step 3 should not execute if 2 fails either because you use an ON
SUCCESS constraint and it did not succeed.

You will either have to add an ON ERROR constraint + step to every work
step you do or get sexy by skipping steps but that could be more trouble
than it's worth.

Allan

"Microlong" <Microlong (AT) email (DOT) com> wrote in message
news:Microlong (AT) email (DOT) com:
No, I don't know the reason why the step4won't run when step2 failed ? Do

you have experience on this case ?

"Allan Mitchell" wrote:

Are you looking for something like

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

"Microlong" <Microlong (AT) email (DOT) com> wrote in message
news:Microlong (AT) email (DOT) com:
I create a package to call other packages in one workflow ,it's very
similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it
runs on

failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure.
Is
there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

#6

Old

Jamie Thomson

Posts: n/a

RE: DTS workflow failure - 02-23-2005 , 07:33 AM

You need an OnFailure precedence constraint going from Step2 to Step4. Have
you tried this?

Just out of interest, what version of DTS are you using?

Regards
Jamie Thomson
An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx

"Microlong" <Microlong (AT) email (DOT) com> wrote

Quote:

I create a package to call other packages in one workflow ,it's very
similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it runs on
failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure. Is
there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

#7

Old

Jamie Thomson

Posts: n/a

RE: DTS workflow failure - 02-23-2005 , 07:33 AM

You need an OnFailure precedence constraint going from Step2 to Step4. Have
you tried this?

Just out of interest, what version of DTS are you using?

Regards
Jamie Thomson
An SSIS blog - http://blogs.conchango.com/jamiethom...tegory/71.aspx

"Microlong" <Microlong (AT) email (DOT) com> wrote

Quote:

I create a package to call other packages in one workflow ,it's very
similar
as below:
Steps----on success--->step2----on success---->step3
-
-----on failure--->step4
for step2, if it runs on success, step3 will run continuous, if it runs on
failure, step4 will run continous.
However, I found that step4 don't run if step2 will run on failure. Is
there
a way to control right workflow logic. thanks for any help

--
Developer
QA Dashboard
Microsoft China Development Centre

Reply With Quote

Reply

« Previous Thread | Next Thread »

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

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.