sql server dts: nesting DTS packages and returning errors -- sql server dts

nesting DTS packages and returning errors

waltmallon NO[at]SPAM yahoo.com
2/19/2004 2:40:41 PM

sql server dts:

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

Re: nesting DTS packages and returning errors

Darren Green
2/19/2004 11:09:13 PM

In message <28db1398.0402191440.6aec774f@posting.google.com>, Walter
Mallon <waltmallon@yahoo.com> writes
[quoted text, click to view]

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