Execute Package Task - Exec Result Status

#1

Hi,

I am calling an 'Execute Package Task' in my DTS package to execute another
DTS package. It looks like the execution status of the inner package is NOT
being carried over tot the calling package. This is what I have:

Package A:-

Package B - on success - Step 2
Package B - on failure - Step 3

The problem is, even if a step fails in Package B, Step 2 is being executed.
Also, the Execute Package step in Package A doesnt show any error in the
log.Has anyone come across this problem?

Thanks for your time and help.

#2

Have the child fail on first error and see if that solves your problem

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arun" <aganesan (AT) esurance (DOT) com> wrote

Quote:

Hi,

I am calling an 'Execute Package Task' in my DTS package to execute
another
DTS package. It looks like the execution status of the inner package is
NOT
being carried over tot the calling package. This is what I have:

Package A:-

Package B - on success - Step 2
Package B - on failure - Step 3

The problem is, even if a step fails in Package B, Step 2 is being
executed.
Also, the Execute Package step in Package A doesnt show any error in the
log.Has anyone come across this problem?

Thanks for your time and help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Execute Package Task - Exec Result Status

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

Execute Package Task - Exec Result Status - 07-09-2003 , 05:54 PM

Re: Execute Package Task - Exec Result Status - 07-10-2003 , 01:47 AM