Microsoft OLE DB provider for Analysis Services 15.0

Pedro Soares 406 Reputation points
2022-07-08T15:09:03.49+00:00

Hi, I started getting an error today while trying to run SSIS Analysis Services Processing Tasks on the Visual Studi 2019:

[Analysis Services Processing Task] Error: Could not load file or assembly 'Microsoft.AnalysisServices, Version=19.22.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

It seems to be the connector to SSAS, which in my case is Microsoft OLE DB provider for Analysis Services 14.0, while SSAS version is 15.XXX. How can I solve this issue? I tried installing the lateste MSOLAP but it didn't help. Microsoft OLE DB provider for Analysis Services 15.0 does not appear as an option whle creating the connection. 14. connects fine but fails at run time. It seems due to latest updates r something, as I didn't have this issue a month ago for sure.

Thank you

EDIT: This only happens in Visual Studio. If I deploy the SSIS Project to the Catalog and run it from there, it works without any issue.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Pedro Soares 406 Reputation points
    2022-07-11T13:06:25.777+00:00

    Hi @ZoeHui-MSFT ,

    Yes I did install both MSOLAP versions. I did not install the other 2 client libraries. Do I need to restart the server after installing? I don't remember doing this on previous versions.

    Thank you


  2. Steen Schlüter Persson 1 Reputation point
    2022-07-13T12:36:30.257+00:00

    I'm having the same problem, and get the same error message. I have tried to install both MSOLAP packages, but that didn't make any difference. Have also tried to restart the PC, but also to no avail.

    One thing that might be worth noticing, is that the SSIS project I'm runing the taks from needs to run in 32-bit debugging mode. This is due to an error that occurred for 2 or 3 versions of VS ago, where it suddenly popped up with an error message when dobugging a SSIS project (any projects - not only SSAS processing projects). Setting the "Run64bitRuntime" to False , was a workaround for this error, but I'm wondering if this could then cause the error when running SSAS processing tasks?

    Regards
    Steen

    0 comments No comments

  3. Pedro Coelho 1 Reputation point
    2022-07-18T14:52:22.08+00:00

    Good Afternoon,

    I'm exactly with the same problem. Since i made the VS update for 16.11.16 version, this error "[Analysis Services Processing Task] Error: Could not load file or assembly 'Microsoft.AnalysisServices, Version=19.22.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified." started to appear when in debug mode i'm trying to run Analysis SErvices Processing Task.

    I uninstall and install VS, i made the the same with OLEDB drivers...and unfortanetly nothing...

    Do you could fix this ?

    Best regards

    0 comments No comments

  4. Pedro Coelho 1 Reputation point
    2022-07-27T11:11:09.967+00:00

    In last update for Microsoft.DataTools.IntegrationServices (539 831KB) , this issue is fixed.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.