I'm trying to query Analysis Services 2000/2005 from SQL Server 2005 without using a Linked Server or OPENQUERY. My thoughts were I could create a .NET assembly that accepts a server name, and mdx to execute, and return the data to SQL Server. Has anyone tried this or is this possible?Thats sure possible e.g. with the oledbconenction object, but you will have to keep in mind that this will the EXTERNAL access and therefore your permission set of the assembly has to be set to this level.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment