以编程方式创建SSIS 2019程序包时出错 [英] Error creating SSIS 2019 package programmatically

问题描述

我能够以编程方式创建包当谈到ssis
2016但是当我尝试以编程方式创建包时，我得到的误差低于。

"无法加载文件或程序集'microsoft.sqlserver.dtsruntimewrap，
version = 15.100.0.0，culture = neutral，publickeytoken = 89845dcd8080cc91'或其依赖项之一。系统找不到指定的文件。"

创建的示例包并上传到一个驱动器位置下方。

https://1drv.ms/u/s!AlyBhK9gzDw2lHGXZzgWLbSNZZ_5

我观察到的是2016年的Microsoft.SqlServer.DTSRuntimeWrap
存在于"C：\ Windows \ Microsoft \\ .NET中\assembly\GAC_32\Microsoft.SqlServer.DTSRuntimeWrap\v4.0_13.0.0.0__89845dcd8080cc91"但是ssis 2019是visual studio 2017安装的一部分，没有安装在GAC_32中，而是安装在"C：\Program Files
（x86）\ Mesrosoft Visual Studio \ 2017 \ Communmunity \ Common7 \\ \\ INTER\CommonExtensions\Microsoft \SSIS \150 \ Binn \ Mysrosoft.SQLServer。 DTSRuntimeWrap .dll" 。

所以使用gacutil将它安装到gac中，但现在我的
错误。

" Microsoft.SqlServer.Dts.Runtime.DtsComException：
'找不到Integration Services类。确保在运行该应用程序的计算机上正确安装了Integration Services。此外，如果您运行的是64位
应用程序，请确保已安装64位版本的Integration Services。"

---

Sam

解决方案

参考以下链接

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/491384d2-02f7- 4178 - a1c3-bcbd58e57fce /一个集成的服务类，不能待发现 - 让 - 确定 - 即整合服务 - 是 - 是否正确？论坛= sqlintegrationservices

I am able to create package programmatically when it comes to ssis 2016 but when i try to create package programmatically i am getting below error.

"could not load file or assembly 'microsoft.sqlserver.dtsruntimewrap, version=15.100.0.0, culture=neutral, publickeytoken=89845dcd8080cc91' or one of its dependencies. the system cannot find the file specified."

Created sample package and uploaded in below one drive location.

https://1drv.ms/u/s!AlyBhK9gzDw2lHGXZzgWLbSNZZ_5

What i have observed is Microsoft.SqlServer.DTSRuntimeWrap for 2016 exists in "C:\Windows\Microsoft.NET\assembly\GAC_32\Microsoft.SqlServer.DTSRuntimeWrap\v4.0_13.0.0.0__89845dcd8080cc91" but ssis 2019 which is part of visual studio 2017 installation didn't install in GAC_32 but installed in "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\Microsoft.SQLServer.DTSRuntimeWrap.dll".

So installed it into gac using gacutil but now i am getting below error.

"Microsoft.SqlServer.Dts.Runtime.DtsComException: 'An Integration Services class cannot be found. Make sure that Integration Services is correctly installed on the computer that is running the application. Also, make sure that the 64-bit version of Integration Services is installed if you are running a 64-bit application."

---

Sam

解决方案

refer following link

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/491384d2-02f7-4178-a1c3-bcbd58e57fce/an-integration-services-class-cannot-be-found-make-sure-that-integration-services-is-correctly?forum=sqlintegrationservices

这篇关于以编程方式创建SSIS 2019程序包时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！