Report Portal

SSIS 2012 - Inserting data into a SQL Server Table from an MDX Query

The reason for this blog post, is I recently had a query if it was possible to get data returned from an MDX Query and then insert the data into a SQL Server Table. And the reason for putting it into SSIS was that we could schedule the job to run on a schedule. I have inserted pictures from my own documentation to save me some time publishing this post.


Tags: mdx, amo, ssis, script


2007-2015 VidasSoft Systems Inc.