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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 8:37 AM
Points: 10, Visits: 107
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 14, 2014 11:03 AM
Points: 10, Visits: 24
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 8:37 AM
Points: 10, Visits: 107
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