I have an execute package that has numerous transform tasks. When the
package is run independently, it works fine. When I execute the package from
within another package, I receive an error stating "Execution was canceled by
user." I've seen the knowledge base article about this error when executing
packages from VB, but can find nothing about this error happening when
packages are run through Enterprise Manager.

Any help is greatly appreciated.

This is an often seen condition and I have never been able to reproduce.
I have had people send me packages that for them returned what you see
and for me worked fine which leads me to think that maybe it is a
combination of things like MDAC maybe ????

Can you run it on any other box?



"Jim Pace" <Jim Pace (AT) discussions (DOT) microsoft.com> wrote