This has also been posted in the DTS NG.....

Hi all,
I have a problem...

I have two DTS packages that run fine, each one contains several steps all
related to build shared dimensions and cubes on the analysis server.

Each package works fine on it's own.

I created another DTS package which simply calls the other two packages. It
has two step, one for each package.

If I run each step of the calling package individually, it works fine,
however, if if hit the run button (even from design mode) to execute all the
steps, the package hangs. There is a workflow connection between the two
steps that is set to 'on success'

To recreate this do the following.
In analysis manager, create a simple shared dimension and a simple cube that
uses that dimension (this relationship may not be relevant but this was my
test model)
Create a DTS package to rebuild the shared dimension, call it BuildDIM
Create a DTS package to rebuild the cube, call it BuildCUBE
Create a DTS package that runs BuidlDIM and BuildCube with a workflow
connection set to 'on success', call it BuildBoth
From BuildBoth's design view, execute the first step manually, when it's
completed execute the second step, both should complete without errors.
Now click the run icon to execute both steps.
The DTS package should now fail.

If anyone has any ides please let me know.

Thanks in advance.

Al.

try to play with the threading model of the packages.
take a look at the properties (right click) of your execute DTS task, and
you'll find a thread option.
I don't remember the name, its something like "execute in main thread"

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

Thanks for the advice but still no luck I'm afraid.

Note this is SQL SERVER 2000. Sorry I shoudl have mentioned that.

The only thread options I could find where the process priority and the
simultaneous tasks limit. I've tried several combinations with no change in
the results.

"Canadean" wrote:

take a look at the properties of the task himself, not the properties of the
package.
(the task which execute the other package)

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