my requirement is like this

i have two pakages
1.inner
2.outer

my flow is like this


if error occured in outer package
then
in err handling work flow ,iam calling inner package.
if error occured in inner package it has to do some error handling
work flow
and it returns failure status to outer package.
in outer package it has to do
some error handling work flow for that execute package task fail.
this is my require ment

outer--failure-calls---->inner-----failure--errhandling for failure
return status failure------->outer package--------failure------->errro
handling for outer package.

iam achieving that by following way

in inner package at initial task i made failOnError to set 0
i am doing error handling work flow
at end i made failOnError to -1
so it exits from the task

so my question is can i use like this operation?

if not suggest me the other solution for this
regards
dasu.g

There is a problem with this scenario. For a parent package to know a child
has failed the child package must have the fail on first error property set.
If you do this then the package fails/stops after the first error, so no on
error constraints will be followed in that child package.

The above applies to using teh Execute Package Task, so you may want to try
and alternative mechansim to execut the child package such as an ActiveX
Script Task.


--
Darren Green
http://www.sqldts.com

"dasu" <dasu_g (AT) rediffmail (DOT) com> wrote

you r right ,
but you did not read my complete mail.
that i specified initially i made failOnError to o so
it will work as normal
when any error occured then i will do error handling flow, after that
i make failOnError to -1
now iam failing the package so it exits from that.

please suggest me the proper approach
regards
dasu.g

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!