Post reply

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

  • 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

  • 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??

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply