SSIS目标组件由于当前版本的数据流而失败
我有一个工作的SSIS包。它从VS起作用，这意味着它可以按预期的构建和执行，从而在CRM中产生结果。
在获取生成的.ispac文件并将其部署到MSSQL Server中后，我失败了。
我会发现一个看起来像这样的错误：
测试软件包：错误：Microsoft.sqlserver.dts.pipeline.com.ponentversionmismatchexception：Create Records的版本与此版本的DataFlow不兼容。 [[[指定组件的版本或管道版本或两者都高于当前版本。该软件包可能是在新版本的DTS或组件上创建的，而不是当前PC上的组件。]] 在Microsoft.sqlserver.dts.pipeline.managedcomponenthost.hostcheckandperformupgrade（IDTSMANAGGECOMPONENDWRAPPER100包装器，INT32 lpipelineversion）。
）。
上述“创建记录”是“ Dynamics CRM目标”组件。
有很多人遇到这样的问题，我搜索了网络，但是所有的建议是我们从VS更改了MSSQL Server的目标版本，但是我尝试过，但它不起作用。
附加信息：
系统：Windows 10 Pro
vs：2015
MSSQL：13.0.6300.2（因此它是SQL Server 2016）
Kingsway版本：v21.2（21.2.0.31501），
“ targetserserververversion”设置为：' SQL Server 2016'
我尝试了什么？
我试图直接从VS部署，但那里没有运气。
我在我的本地机器上运行了相同的（单独构建的）SSIS，在该机器中拥有VS2019和SQL Server 2019，在这里工作正常。
我试图在主机上的VS2019中构建该项目，但仍遇到同样的错误。
那么，您是否知道发生了什么事，您能给我一些建议吗？
I have a working SSIS package. It works from vs, meaning it builds and executes as expected producing results in the CRM.
After I get the generated .ispac file and deploy it in MSSQL server, I fail on executing.
I get an error that looks like this:
Test Package:Error: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of Create Records 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).
The aforementioned 'Create Record' is the 'Dynamics CRM Destination' component.
There are many who have such issue, I searched the web, but what all suggest is that we change the target version of the MSSQL server from VS, but I tried that and it doesn't work.
Additional information:
System: Windows 10 pro
VS: 2015
MSSQL: 13.0.6300.2(so it's sql server 2016)
Kingsway version: v21.2(21.2.0.31501)
The 'TargetServerVersion' is set to: 'SQL Server 2016'
What have I tried ?
I have tried to deploy straight from VS, but no luck there.
I ran the same(separately built) SSIS on my local machine where I have vs2019 and sql server 2019, it works fine in here.
I tried to build the project in vs2019 on the main machine and I'm still getting the same error.
So, do you have any idea what's happening, can you give me some advice ?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
感谢您对我们集成工具包的问题。要使用我们的任何工具包进行部署和计划执行，应将相同版本安装在可能的三个位置：
，是您未安装我们的Dynamics 365工具包，或者在服务器上安装的版本低于您已安装的版本在您的开发工作站上。
Thank you for the question about our integration toolkit. To use any of our toolkits for deployment and scheduled execution, the same version should be installed in possibly three places:
Based on the error message, it is either that you didn't install our Dynamics 365 toolkit or otherwise the installed version on the server is lower than what you have installed on your development workstation.