I dig a little bit as this limit exists both in SSIS and SSAS. I currently find no work around for this, I will try to find some new ways if possible.

Have you resolved your issue ?

Is there any news about this issue that you could share ?

Since the sync could be done manually with sync wizard, also the mdx works in SSMS.
I suspect it could be more an issue with in SSIS .
As for the database name , have you change it to the right name in your SSIS work flow and see if it works for you.

Hi,

Any success? Have you achieved your goal?

Hi
A little bit curious what you mean by "deny data" ?
Since you have resolved the issue, would you mind to share you solution so community member could benefit from it ?

Great Solution !

Hi,
Did this help? Have you resolved your issue?

Hi,

Was your problem solved ? Should the answer help? We would like to know your feedback! :)

Hi,

We had not heard from you back， have you resolved your issue ? Could we offer more support?

Did this issue remain or have you resolved it ? Any feedback is welcome! :)

I did some research online, but sorry, that with only this Error Code, I could not locate the problem because lack of sufficient document. You may consider contact Microsoft support, they may resolve this with internal documentation or remote desktop help.

Hi,

Anything new about this issue ， if the issue still exists could you give some Engilsh information?

Hi,

Have you solved the problem with the post ? If Alexei's solution helps, you could mark it as answer , if not, you could tell us what's you currently facing .

Should this solve your issue ? Any feedback is welcome !

Did you solve the problem with Darren's answer? Could we know your progress of the issue ?