I've noticed that when I have a sql server agent job that calls a DTS
package, and that package in turn calls another DTS package, when the
inner package fails, it does not return an error to the outer package
and hence the sql server agent job indicates success even though the
inner dts package failed.

Is there a way to get the sql server agent job to indicate a failure
when the inner dts package fails?

Thanks in advance.

Walter
waltmallon (AT) yahoo (DOT) com

In message <28db1398.0402191440.6aec774f (AT) posting (DOT) google.com>, Walter
Mallon <waltmallon (AT) yahoo (DOT) com> writes
If using the Exec Pkg Task, you need to set the package option "Fail on
first error" to true, for the child package. Unfortunately this has the
side-effect that you cannot use On Error workflow in the child package.
If this is a problem then try using ActiveX Script instead.

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

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