Hello,

My question is about the result of an Execute Package Task in DTS. The
situation:
There are 2 packages:
- Package A
->Task: 'Execute Package B'
- Package B
-> Error in some task.

I want to see in Package A whether Package B ran well. In case package B
failed, Package A should fail as well. I can get this to work, but only (!)
if I have unselected the option 'Log execution status to SQL Server' in the
'Logging' tab of the 'Package Properies' of package B.
I discovered this after trying and testing many failure handling options,
but in Package B I really have to unselect 'Log execution status to SQL
Server', otherwise Package A will not notice the failure in Package B. This
is not what I like, because we need the log information on SQL Server.

Can anyone tell me why this occurs and whether there are workarounds for
this particular problem? (I tried running package B from an ActiveX script,
same result!)

Thanks in advance!