Unanswered: Analysis Services Processing Task hanging up DTS Package execution
I am trying to run a multi-package ETL process where I execute the top level package which contains a few "Execute Package Tasks". Control is returned to the top level package each time except for the package which contains a "Analysis Services Processing Task" - when I remove this task, everything works just fine. Is there a bug here or am I just missing something?
I encountered the exact same thing. It has something to do with different 'threading models'. The workaround is that you have to make sure that the the task 'runs in the main thread'.
This is an option within the task in DTS that is not selected by default.
I don't know exactly which tab it is now, bt you should be able to find it in either the props or the advanced props of the task.