InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 06:51:31 GMT20http://www.sqlservercentral.com/Forums/Topic1425167-147-1.aspxHiI 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!! :-)ThanksMichaelThu, 28 Feb 2013 10:12:23 GMTMichaelMontgomery