Returns less number of records when ran in parallel

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  January 21, 2018 at 8:19 pm

  #341838

  Hi All,

  I have two different databases and cubes one on each db. I have created two ssis packages to extract data from each cube . The number of records extracted are around ~30mil on each cube. The issue i am facing is when i ran both the jobs in parallel i don't see all the records being extracted from cube but when ran in sequence i see all the records getting populated in the table though they are two different cubes and databases. I tried to check the load on SSAS server and it doesnt seem to be a problem .

  The storage setting is MOLAP and i use MDX query from my SSIS server to extract the data from cube to database.

  Server - DB1 - Cube 1
  Server - DB2 - Cube 2 

  I have tried below fixes but didnt work:
  1.I tried to split the recordset within SSIS package but it didnt help. 
  2. Changed the data access mode from fast load to table or view

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman