SSIS ADO.NET Source : Error while running MDX in SQL managed instance from AZure VM(SSAS Cube)

Question

SSIS ADO.NET Source : Error while running MDX in SQL managed instance from AZure VM(SSAS Cube)

Thayananthavel Sreedharan 1

Hi All,

1.we have deployed our SSAS Multi dimensional cube in Azure VM SQL instance
2. Calling the SSIS package to run the MDX query as ADO.NET source from Azure SQL managed instance .
but while running from SQL job , we are getting the below error
@

Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator

2021-07-14T14:16:48.97+00:00

Hi @Thayananthavel Sreedharan ,
Thanks for using Microsoft Q&A !!
Can you please share the error message you are getting ?

Thanks
Saurabh
CarrinWu-MSFT 6,891 Reputation points

2021-07-20T03:11:20.547+00:00

Hi @Thayananthavel Sreedharan , we didn't get a reply from you, any update for this thread?
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator

2021-07-22T18:39:56.437+00:00

Hi @Thayananthavel Sreedharan ,

We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh