DTS Package executing packages hangs

[dean12]

I've got three packages: A, B, C.

A executes a bunch of SQL stored procedures.

B executes Analysis Services and updates a data cube

C executes package "A" then package "B".

Both "A" and "B" operate just fine if executed manually.

When I execute package "C", then package "A" completes and I see a message that package "B" started but it doesn't seem to progress. It just hangs almost like these is some type of locking problem.

Any ideas?

 

[dean12]

Also, I tried manually executing the two steps of package "C" - no problems, each step executes and completes successfully.

 

[dean12]

Well, I think I found the answer. On Microsoft's site there is a note that Analysis Services tasks will not run in a package that is executed by another package because of its threading methods.

I moved the Analysis Services steps to the main package and it runs.