This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 5%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
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 @Pedro Soares ,
Have you installed the MSOLAP (x86) for the VS is a 32bit application?
https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=sql-analysis-services-2022
Also try to re-add the component to see if it is helpful.
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
Please restart for a try.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 76%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 45%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
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.