在SQL Server 2016上运行带有脚本组件的SSIS包会导致错误组件不匹配异常 [英] Running SSIS package with script component on SQL Server 2016 gives error Component Mismatch Exception
问题描述
我在SQL Sever 2016上部署了SSIS项目,该项目有一个使用脚本组件的软件包,该软件包在VS 2017上本地运行时没有错误,但在部署时会出错。 / p>
我试过的解决方案
1)将目标版本更改为SQL Server 2016在SSIS项目中
2)将脚本组件上的.NET运行时更改为4.6
,仍然没有运气。任何帮助将不胜感激
错误报告 -
数据流任务1:错误:Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException:脚本组件的版本与此版本的DataFlow。[[指定组件的版本或管道版本或两者都比当前版本高出
。 此软件包可能是在新版本的DTS或组件上创建的。安装在当前PC上。]]¥b $ b at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper,Int32 lPipelineVersion)
数据流任务1:错误:"脚本组件"的组件元数据无法升级到组件的较新版本.PerformUpgrade方法失败。
嗨 TANZEEL1994,
1.将目标服务器版本更改为SQL Server 2016。
2.再次部署整个项目。
3.使用SSMS中的脚本组件执行包。
最好的问候,
Mona Lv
I have SSIS project deployed on SQL Sever 2016, the project has a package that uses script component, the package runs with no errors locally on VS 2017 but when deployed gives error.
Solutions that I tried
1)Changed the target version to SQL Server 2016 in SSIS project
2)Change the .NET runtime on script component to 4.6
,still no luck .Any help would be appreciated
error report-
Data Flow Task 1:Error: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of Script Component is not compatible with this version of the DataFlow. [[The version or pipeline version or both for the specified component is
higher than the current version. This package was probably created on a new version of DTS or the component than is installed on the current PC.]]
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)
Hi TANZEEL1994,
1.Change the Target Server version to SQL Server 2016.
2.Deploy the whole Project again.
3.Execute the package using script component in SSMS.
Best Regards,
Mona Lv
这篇关于在SQL Server 2016上运行带有脚本组件的SSIS包会导致错误组件不匹配异常的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!