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