Just Learned - SSIS SQL Task can execute MDX statements

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

SSIS SQL Task can execute MDX statements

Aug 3 2011 10:33AM by Guenter

While looking for a method to execute MDX statements inside a SSIS package I found out, that you can use the SQL Task for this purpose.

Just set the Connection Type to "ADO.NET" and IsQueryStoredProcedure to "False", supply the SQL Task with an OLEDB Connection of type ".NET Providers for OleDb\Microsoft OLE DB Provider for Analysis Services" and enter the MDX statement as SQL statement.

(I found out about this on SQL 2005)

Read More.. [0 clicks]

Published under: SQL Server Tips · · · ·

Previous: Yield keyword in csharp 2.0 and onwards
Next: Get last day/date of Month for specified date in SQL Server

Guenter

28 · 6% · 1822

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

1 Comments

Have you tried this on 2008 R2? I have got the execute SQL task to run successfully but my MDX statement (tested in sql management studio) is not actually updating the cube. Did you add a "commit transaction" to your statement somehow?

commented on Oct 26 2012 5:47AM

maxwellhill

2891 · 0% · 2

Your Comment

Sign Up or Login to post a comment.

"SSIS SQL Task can execute MDX statements" rated 5 out of 5 by 5 readers