I have an Analysis Services Task where I'm processing a measure group that has about 200 million rows behind it split up into 40 AS partitions.
When I run the task, it finishes the processing and then hangs.
Does anyone know of a way I can diagnose what response SSIS might be waiting for that AS isn't sending?
Thanks
Mark