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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS SQL Command Running MDX query Returns...

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

Rate Topic

Display Mode

Topic Options

Author

Message

MichaelMontgomery

Posted Thursday, February 28, 2013 10:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 6:57 AM
Points: 6, Visits: 84

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!! Smile

Thanks
Michael

Post #1425167

« Prev Topic | Next Topic »

Permissions