Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS SQL Command Running MDX query Returns different results on each execution Expand / Collapse
Author
Message
Posted Thursday, February 28, 2013 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 23, 2014 6:15 AM
Points: 7, Visits: 99
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
Post #1425167
Posted Thursday, February 27, 2014 2:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:08 PM
Points: 9, Visits: 13
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??
Post #1546125
Posted Thursday, February 27, 2014 4:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 23, 2014 6:15 AM
Points: 7, Visits: 99
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
Post #1546170
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse