I appear to be having the same problem as the person in this thread http://asstoredprocedures.codeplex.com/discussions/216480

I have the newest version installed. The procedure works fine when I run it against analysis services without using openrowset.

When I try to run the following query I get the same error message as in the thread I linked.

select *  from openrowset('MSOLAP','Datasource=server1molap;initial catalog=[Mart_Test];','CALL ASSP.discoverXmlMetaDataFull("\Database|Name\Cubes\Cube\MeasureGroups\MeasureGroup\Partitions\Partition");')

So next I created a linked server and try running the following.

select * from openquery(server1molap,'CALL ASSP.discoverXmlMetaData("\Database|Name\Cubes\Cube\MeasureGroups\MeasureGroup\Partitions\Partition");')

But I get: Exception has been thrown by the target of an invocation.Index was outside the bounds of the array error.

Any help is appreciated

Hi there, I think I found this issue. I've checked in a change to the source and just need to coordinate with the other guys on the team before doing another release.

Thanks for looking into this. Do you have an estimate when the new release will be available?

The new version is working with openquery and a linked server.

Thanks!