How to run MDX/Create local cubes from SSIS

Just drag an Execute SQL Task and double click to open SQL Task Editor. Under the SQL Statement section, you will find the slot for Connection.

Click on New connection and you will see the Configure OleDb connection Manager window. Click on the New button.

Now , you will find the window called Connection Manager. Click the provider called Native OleDb/SQL Server Native Client and choose Microsoft OLEDB provider for Analysis Services 10.0.

Now, click ok and go back to the SQL Task Editor window and write your MDX statement (I used a Create Global Cube statement for creating a local cube). Now, you can exeucte the task and see the result.

3 thoughts on “How to run MDX/Create local cubes from SSIS

  1. This was extremely helpful. I’m hoping to use this for an ALTER CUBE statement to set a default member on a role playing dimension.

  2. Hi, I just learned this is not the right way to do an ALTER CUBE statement. It needs to go into the cube calculations tab. Live and learn.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.