I am trying to run data mining query task in SSIS project in visual studio. Analysis service instance is running on azure cloud. I am trying to execute mdx query to retrieve data from AAS.

Connection to Azure Analysis Service is set up via Microsoft OLE DB Provider for Analysis Service 14.0.

When task is executed, following error occurs:

Error: 0x0 at Data Mining Query Task: Failed to execute data mining query due to the following error: Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal.AdomdClient, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Task failed: Data Mining Query Task

As per error description, I installed ADOMD drivers from here: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers

How can I get past this error? Despite of installing ADOMD drives, Am I missing something regarding assembly it is trying to find?

0

There are 0 best solutions below