SSIS SQL Command Running MDX query Returns different results on each execution

• MichaelMontgomery

  Mr or Mrs. 500

  Points: 561

  More actions

  February 28, 2013 at 10:12 am

  #290135

  Hi

  I have an SSIS package which executes MDX in SQL command data access mode against a cube. When the MDX executes, it inserts the rows into a sql table. The data in the cube should not be changing.

  When I run the MDX through management studio it returns the exact same results every time. I do this before and after the package runs. The MDX I run is exactly the same as that in the package.

  When I run the SSIS package through a SQL job the number of rows changes each time. Eventually, after a few runs the SSIS package returns the correct number of rows.

  Anyone experienced this before, I think I am loosing my marbles!!

  Thanks

  Michael

• cschuck

  Valued Member

  Points: 56

  More actions

  February 27, 2014 at 2:04 pm

  #1692884

  I'm experiencing something similar - one query in the package returns the right number of rows after 2 or 3 runs, with each successive run returning more rows. Did you find any help on this problem??

• MichaelMontgomery

  Mr or Mrs. 500

  Points: 561

  More actions

  February 27, 2014 at 4:38 pm

  #1692924

  Hi cschuck

  Unfortunately we didnt get to the bottom of this one. We actually change the mdx to have less attributes which resolved the problem. I dont think this is the solution but it worked around the issue.

  Let me know if you get a resolution

  Michael