SSAS as data source. MDX Query executed twice.

I'm trying to extract some complex data out of a cube. I've noticed that the query is executed twice by SSIS. Once to get the metadata and once to pull out the data.

I've tried both the oledb and ado.net connectors. I've tried disabling validation etc but it hasn't helped.

Is there a way to have SSIS query a cube just once? My queries take tens of minutes to hrs to run, so having them execute twice will mean the package will run twice as long

How do reporting tools do it? they use the oledb driver and dont query the cube

August 25th, 2015 11:59pm

Hi jakubk,

You cannot disable the validation part completely. But I do not see why the metadata discovery would take so long. It is not the case typically. I just assume there is other factors that impose this delay.

Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 10:21am

Hi jakubk,

You cannot disable the validation part completely. But I do not see why the metadata discovery would take so long. It is not the case typically. I just assume there is other factors that impose this

August 26th, 2015 8:53pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics