Forum Discussion
Error 0x80004005 during SSIS package execution with SSAS source
Hi.
I've created a SSIS package utilizing a SSAS source (VS 2022 Developer Edition, SSAS 2019 15.0.35.48). I can confirm that I can connect to my SSAS source through OLE DB connector and run MDX queries:
When I run the package, "Connection Test" step passes (it runs a simple MDX query against the SSAS source to ensure we can connect to source):
But data flow task fails on OLE DB Source as follows:
My problem is that there is nothing in error message which can help me where is the exact problem. I've seen many posts on this problem, but none of them has worked for me as each focus on a part of error message following the above message, which doesn't exist in my case (e.g. "Communication link failure" or "TCP Provider: The specified network name is no longer available").
Please help.
Thanks in advance.
Finally managed to solve it. I added "Format=Tabular" in connection string's XML code and problem gone.
- mohammadjavaheryCopper Contributor
Finally managed to solve it. I added "Format=Tabular" in connection string's XML code and problem gone.