Hi !

Is anyone has any idea why it happends ?
That's my story:
package A invokes package B (as execute package task) and this invokes
package C (as execute package task), which consits several tasks. Among them
there is a group tasks, where every task is an execution of another package
(lets call them Y1, Y2 ...). In every of "Y-type" package there is execution
of external program.

This ambigeus construction works, when runs from Enterprise Manager or via
DTSRun.
But it fails, when I try to run it from within stored procedure (where
package A is loaded and executed using sp_OAxx procedures). After many
experiments I know as follows:
a) the error is generated by any task called after completion od Y1 task
(execution of package with external program).
b) there is a difference in behaviour of that, when execution package task
is replaced by Active X script, with code loading and executing package.

Does execution in package main thead matter ? I set it for all tasks and
can't see the difference.

Any help will be appreciated.

P.S.
1. SQL server runs on regular windows (with admin rights) rather then
LocalSystem account.
2. I'm executing my proc from Query Analyzer.
--
Tomek Romanowski