I have a 'Execute Package' task that executes a package having an
ActiveXScript task and 2 transforms tasks. When I run the inner package
standalone it runs fine.
When I run it from the outer package, only 1 of the transform tasks is
executed. The strange part is that the transform that gets run is the last
one I clicked on before saving the inner package. The 2 transform tasks in
the inner package are both between the same connections (Access and Sql
Server). Any ideas?

Have you turned on the error log file for the package and the datapumps?
What do they tell you?
Are the DataPump tasks trying to run in parallel, if so try serialising them
with workflow for now.


--
Darren Green
http://www.sqldts.com


"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

Hi Darren,

TFYR,
The problem seems to have something to do with having the package designer
open at the same time that it is being run. I closed the inner package and
then refreshed the 'Execute Package Task' with the most current Package GUID
and then it worked.
Thanks for your help, particularly the suggestion to turn the error log file
on.

Best regards,
Al

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote