SSIS Analysis Processing Task Error: Exception has been thrown by the target of invocation.

Suresh Veesam 21 Reputation points
2021-01-26T00:05:09.273+00:00

Hi

I'm trying to process an object (Process Full) in the Azure Analysis Services through Analysis processing task and getting below error when executing the SSIS package.

Exception has been thrown by the target of invocation.

I'm able to test the Analysis Services connection successfully, but not sure the reason for the error.

Could anyone let me know why I'm getting this error?

Thanks in advance

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 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,244 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-01-26T07:53:21.177+00:00

    Hi,

    This is not a very clear error info and could be multiple reasons .
    You could check your steps with this blog of tutorial see did you miss some steps or anything else could help : process Azure Analysis Services with SSIS.

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November