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.
Excel Can not Connect SSAS in Sql server 2000
Hello I have Questions about Analysis service in Sql server 2000 Now I can not use EXCEL to connect to SSAS. Now I'm cannot using EXCEL to connect to SSAS by choosing an approach from Analsis Services. If you choose to connect to the database From Sql Server can connect. I installed microsoft office web components 2003 My Excel Version 2013
Cannot Release Lock on SharePoint Online File
Hi How can I get an xls hosted on SharePoint Online to pull data from a Analysis server cube hosted onPrem? Looking at On-Premise Data Gateway but not sure if that will work? Something like this maybe possible? (Orange is existing infrastructure) Thanks in advance.
