Set the child packages (in the child package) to Fail on First Error.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Gaye Finn" <anonymous (AT) discussions (DOT) microsoft.com> wrote

other ones execute. All execute packages are linked with the 'On Success'
Workflow. However, when one of my Packages fails the next Package is
executed anyway regardless of the failure. Its as if the parent package is
getting returned a success result instead of a failure.

I have set the Child Packages to Fail on First Error and it now works fine. But there are tasks I need to perform (deletion of temp tables etc) in the child packages if an error occurs. When the fail on first error is set the 'On Failures' task does not execute. I need to be able to run the Child Packages both stand alone and within a parent package, so the cleanups need to be done in the Child Package. Is there any way around this??

In message <25643BAA-A765-44B1-8422-464D3BD69026 (AT) microsoft (DOT) com>, Gaye
Finn <anonymous (AT) discussions (DOT) microsoft.com> writes
Not if using the Execute Package Task. Your choices are-

Use ActiveX Script

Execute a package from a package
(http://www.sqldts.com/default.aspx?215)

Use VB, implement this either as COM object or a custom task of your
own. VB has better error handling options in the form of events.

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208)

Both of these options loose the ability to implement a package
transaction that spans the parent and child packages.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org