找不到方法:Microsoft.AnalysisServices [英] Method not found: Microsoft.AnalysisServices

问题描述

我使用 SSIS 包为数据仓库创建了 ETL 设置.一切正常，直到最后一步是分析服务处理任务编辑器"

I have created an ETL setup for a datawarehouse with SSIS packages. Everything is working fine until the very last step which is a "Analysis Services Processing Task Editor"

每当我添加我的立方体并按确定时，我都会收到以下错误:

Whenever I add my cube and press ok I get the following error:

"方法未找到:"'Void Microsoft.AnalysisServices.Commands.ProcessCommand.set_Type(Microsoft.AnalysisServices.ProcessType)'.

"Method not found: "'Void Microsoft.AnalysisServices.Commands.ProcessCommand.set_Type(Microsoft.AnalysisServices.ProcessType)'.

我怀疑 DLL 存在一些问题，但我不确定是哪个问题.我在我的 SQL Server 安装 (C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies) 下找到了一个 Microsoft.AnalysisServices.dll我在 Visual Studio 安装文件夹中没有找到它.

I suspect there is some issue with a DLL, but I'm not sure which. I found a Microsoft.AnalysisServices.dll under my SQL Server install (C:\Program Files (x86)\Microsoft SQL Server\120\SDK\Assemblies) I did not find it in my Visual Studio installation folders.

推荐答案

我找到了解决方法.

我试图用 AdventureWorks 数据集重现问题，以验证问题是由于 .dll 而不是我的多维数据集或其他任何东西引起的.

I was trying to reproduce the problem with the AdventureWorks dataset, to verify that the problem was occuring due to the .dll and not my cube or anything else.

所以我创建了一个新的 OLTP &DWH 与 AdventureWorks 数据集中的 Cube，并创建了一个新的 SSIS 项目，其中唯一的步骤是处理多维数据集.

So I created a new OLTP & DWH with Cube from the AdventureWorks dataset and created a new SSIS project where the only step was to process the cube.

使用此设置后，我没有遇到与原始项目相同的错误，似乎 .dll 没有任何问题?

With this setup I did not get the same error as I did on the original project, seemingly, there was nothing wrong with the .dll?

然而，我也尝试将目标服务器和立方体更改为我原来的服务器，令我惊讶的是它奏效了！

However I also tried changing the target server and cube to my original one, and to my surprise it worked!

所以我保存了该包并将其导入到我的原始项目中，然后从那里执行该包并且它可以工作.

So i saved that package and imported it into my original project and excecuted the package from there and it works.

另请参阅 Pavel 的 possbile 解决方案.

Please also see Pavel's possbile solution.

奇怪的是，如果我们在项目部署模式下创建新的 SSIS 项目，保留 2017 版本，并将其部署在我们的 2016 SSIS 服务上 - 一切正常.所以...我们只需要迁移到项目部署模式 ))) – Pavel Botygin

Strange thing, if we create new SSIS project in Project deployment mode, leave 2017 version, and deploy it on our 2016 SSIS services - all is working perfectly fine. So... we just need to migrate to the Project deployment mode ))) – Pavel Botygin

这篇关于找不到方法:Microsoft.AnalysisServices的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！