dbTalk Databases Forums  

On Failure WorkFlow

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


Discuss On Failure WorkFlow in the microsoft.public.sqlserver.dts forum.



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

Default On Failure WorkFlow - 09-10-2003 , 03:43 AM






Hi,
I have a bunch of tasks, Which should be executed on
failure of a certain task,
For eg:If a task A fails I need TaskB,TaskC,TaskD and
Taske to be executed
So I set a on failure workflow between TaskA and TaskB
and On success workflow between TaskB TaskC TaskD and
TaskE

Problem:- It is executing TaskB alone TaskC and TaskD are
being Designated as "NOTRUN" WHY?
Thanks in Advance
Ravi


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: On Failure WorkFlow - 09-10-2003 , 04:01 AM






So it follows the "On Failure" workflow from A --> B but then B succeeds and
nothing happens?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Ravi" <rravi3 (AT) Covansys (DOT) com> wrote

Quote:
Hi,
I have a bunch of tasks, Which should be executed on
failure of a certain task,
For eg:If a task A fails I need TaskB,TaskC,TaskD and
Taske to be executed
So I set a on failure workflow between TaskA and TaskB
and On success workflow between TaskB TaskC TaskD and
TaskE

Problem:- It is executing TaskB alone TaskC and TaskD are
being Designated as "NOTRUN" WHY?
Thanks in Advance
Ravi




Reply With Quote
  #3  
Old   
ravi
 
Posts: n/a

Default Re: On Failure WorkFlow - 09-10-2003 , 04:22 AM



Yes , Task A Fails as a result Task B Gets Executed but
the rest of the tasks that depend on succesfull execution
of taskB dont get executed Inspite of Task B getting
executed successfully
Ravi

Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: On Failure WorkFlow - 09-10-2003 , 05:20 AM



It would seem that your constraints are confused.

I have just set up a very Quick package that does this



------> On Success --> T3
T1---> On Failure --> T2 ------> On Success --> T4
-------> On Success --> T5


This works fine.

Have a look in Disconnected edit at what the package thinks the constraints
are.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"ravi" <rravi3 (AT) covansys (DOT) com> wrote

Quote:
Yes , Task A Fails as a result Task B Gets Executed but
the rest of the tasks that depend on succesfull execution
of taskB dont get executed Inspite of Task B getting
executed successfully
Ravi



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.