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.
where to download the '"Microsoft OLE DB Providers for SQL Server" for WinXP and Win 2008
Hi all, My customer needs to download the OLE DB Provided for SQL Server for WinX and Win 2008 versions. We understand that XP and Win 08 is out of support already. But just wondering if you may have any other inputs to help us please? Many thanks! Corrine
