Aceessing 2 different dimension from same cube in 2 different packages ?

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  September 25, 2014 at 1:37 am

  #150782

  Hi All,

  I would be proceesing dimensions in my SSIS packages. And i want to run packages in parallel.

  Suppose i have a cube name as AdventureWorks and have 2 dimesions say A and B.

  Dimesion A would get process in SSIS package A , where as dimension B would get process in SSIS package B.

  Now i want to run SSIS packages A and B in parallel.

  Is it possible , I mean there would not be any deadlock?

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  September 25, 2014 at 4:47 am

  #1748091

  Normally this won't be an issue. SSAS can process multiple objects at once.

  This is quite common actually and you don't need two packages to process them in parallel.

  With the SSAS processing task, you can process multiple objects at once in parallel in the same transaction.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP