Hi @ZoeHui-MSFT ,
Yes I did install both MSOLAP versions. I did not install the other 2 client libraries. Do I need to restart the server after installing? I don't remember doing this on previous versions.
Thank you
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi, I started getting an error today while trying to run SSIS Analysis Services Processing Tasks on the Visual Studi 2019:
[Analysis Services Processing Task] Error: Could not load file or assembly 'Microsoft.AnalysisServices, Version=19.22.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
It seems to be the connector to SSAS, which in my case is Microsoft OLE DB provider for Analysis Services 14.0, while SSAS version is 15.XXX. How can I solve this issue? I tried installing the lateste MSOLAP but it didn't help. Microsoft OLE DB provider for Analysis Services 15.0 does not appear as an option whle creating the connection. 14. connects fine but fails at run time. It seems due to latest updates r something, as I didn't have this issue a month ago for sure.
Thank you
EDIT: This only happens in Visual Studio. If I deploy the SSIS Project to the Catalog and run it from there, it works without any issue.
Hi @ZoeHui-MSFT ,
Yes I did install both MSOLAP versions. I did not install the other 2 client libraries. Do I need to restart the server after installing? I don't remember doing this on previous versions.
Thank you
I'm having the same problem, and get the same error message. I have tried to install both MSOLAP packages, but that didn't make any difference. Have also tried to restart the PC, but also to no avail.
One thing that might be worth noticing, is that the SSIS project I'm runing the taks from needs to run in 32-bit debugging mode. This is due to an error that occurred for 2 or 3 versions of VS ago, where it suddenly popped up with an error message when dobugging a SSIS project (any projects - not only SSAS processing projects). Setting the "Run64bitRuntime" to False , was a workaround for this error, but I'm wondering if this could then cause the error when running SSAS processing tasks?
Regards
Steen
Good Afternoon,
I'm exactly with the same problem. Since i made the VS update for 16.11.16 version, this error "[Analysis Services Processing Task] Error: Could not load file or assembly 'Microsoft.AnalysisServices, Version=19.22.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified." started to appear when in debug mode i'm trying to run Analysis SErvices Processing Task.
I uninstall and install VS, i made the the same with OLEDB drivers...and unfortanetly nothing...
Do you could fix this ?
Best regards
In last update for Microsoft.DataTools.IntegrationServices (539 831KB) , this issue is fixed.