dbTalk Databases Forums  

adding ON FAILURE sub_packages to Packages

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


Discuss adding ON FAILURE sub_packages to 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 to Packages - 01-10-2005 , 08:08 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   
Wm. Scott Miller
 
Posts: n/a

Default Re: adding ON FAILURE sub_packages to Packages - 01-10-2005 , 10:48 AM






Joseph:

A little common problem when executing packages through the Execute Package
Task: You must check the "Fail package on first error" on the Logging tab
of the Package Properties for the callee (child package) for the failures to
propogate up to your caller package. Otherwise, the child package will
always return Success to the caller and your illustration will always
execute A then B then C no matter if the child packages succeed or fail.

Scott

"Joseph Mong" <anonymous (AT) discussions (DOT) microsoft.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
  #3  
Old   
 
Posts: n/a

Default Re: adding ON FAILURE sub_packages to Packages - 01-11-2005 , 08:41 AM



Thank you Scott:
I actually had to remove the "Fail package on first error"
because I needed the ON FAILURE child packages to execute.
Thanks again.

Joseph

Quote:
-----Original Message-----
Joseph:

A little common problem when executing packages through
the Execute Package
Task: You must check the "Fail package on first error"
on the Logging tab
of the Package Properties for the callee (child package)
for the failures to
propogate up to your caller package. Otherwise, the
child package will
always return Success to the caller and your illustration
will always
execute A then B then C no matter if the child packages
succeed or fail.

Scott

"Joseph Mong" <anonymous (AT) discussions (DOT) microsoft.com> wrote
in message
news:10f901c4f71d$e7b4e200$a501280a (AT) phx (DOT) gbl...
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.