Consider changing the PROVIDER in the connection string to MSOLAP.7

Winnie zhang 106 Reputation points
2021-11-16T02:42:53.467+00:00

I have SQL server 2016 Sp3 installed. However, when we connection to SSAS from SSIS package. The error shows below when connection to SSAS.
Consider changing the PROVIDER in the connection string to MSOLAP.7 or visit http://www.microsoft.com/downloads to find and install support for MSOLAP. Execution of DDL failed.

I checked the registry. the MSOLAP and MSOLAP.7 MSOLAP.8 are there.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,847 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,000 questions
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,796 Reputation points Microsoft Employee
    2021-11-16T09:24:47.937+00:00

    Hi @Winnie zhang ,

    Welcome to Microsoft Q&A!

    Please try to remove MSOLAP in your side, and then reinstall it. You can download it from this link. Please feel free to let me know if there has any other issue.

    Best regards,
    Carrin


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

0 additional answers

Sort by: Most helpful