dbTalk Databases Forums  

Adding ON FAILURE Sub-Packages

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


Discuss Adding ON FAILURE Sub-Packages in the microsoft.public.sqlserver.dts forum.



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

Default Adding ON FAILURE Sub-Packages - 01-10-2005 , 08:21 AM






My later addition of ON FAILURE sub-packages are not being
executed and yet there is failure.

Illustration:
Suppose package

A--success-->B--success-->c

is already pre-compiled/Executed (and is running fine).
On adding ON FAILURE D, E and F i.e

A--success-->B--success-->c
Quote:
| |
Failure Failure Failure
| |
D E F

D does not execute when A fails, neither does E Execute
when B fails and the same applies to F when C fails.
The execution sequence shows D, E and F being placed after
C.
Isn't there some setting that I need to configure? I have
made sure that the work flow properties of D has Source
Step = A, Precedence = Failure and Destination Step = D
and the same configuration applies to E and F.

Jm



Reply With Quote
  #2  
Old   
Ilya Margolin
 
Posts: n/a

Default Re: Adding ON FAILURE Sub-Packages - 01-12-2005 , 07:24 AM






Joseph,

Make sure Fail Package on First Error package property and Fail Package on
Step Failure individual step properties are not set. If they were no step is
executed after a failure even with a fail constraint.

Ilya

"Joseph Mong" <obonyo_2000 (AT) yahoo (DOT) com> wrote

Quote:
My later addition of ON FAILURE sub-packages are not being
executed and yet there is failure.

Illustration:
Suppose package

A--success-->B--success-->c

is already pre-compiled/Executed (and is running fine).
On adding ON FAILURE D, E and F i.e

A--success-->B--success-->c
| | |
Failure Failure Failure
| | |
D E F

D does not execute when A fails, neither does E Execute
when B fails and the same applies to F when C fails.
The execution sequence shows D, E and F being placed after
C.
Isn't there some setting that I need to configure? I have
made sure that the work flow properties of D has Source
Step = A, Precedence = Failure and Destination Step = D
and the same configuration applies to E and F.

Jm




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.