Dec 18, 2011 at 3:46 AM
Edited Dec 18, 2011 at 3:47 AM
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.
from openrowset('MSOLAP','Datasource=server1molap;initial catalog=[Mart_Test];','CALL
So next I created a linked server and try running the following.
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