我正在使用SSIS与Visual Studio 2019一起在SQL Server 2019上创建和部署软件包。最初，当我的软件包在SSDT上运行时，我将其部署在SSMS Integration Server上，但没有输出。
因此，我在Visual Studio 2019中检查了：项目 - ＆GT;项目属性 - ＆GT;配置属性 - ＆gt;一般 - ＆gt; Target版本，设置为 sql Server 2022 ，因此我将其更改为 sql Server 2019 。
当我尝试在Visual Studio 2019中再次运行包裹时，我会收到此错误：
无法加载软件包“无法将com对象施加type'system .__ comobject'到接口type'microsoft.sqlserver.dts.runtime.wrapper.sql2019.idtsapplication160'。与IID'{037FE238-12C5-4313-AE13-9E116E90ACEA}接口的组件由于以下错误而失败：不支持此类接口（hresult：0x80004002（e_noInterface）（e_noInterface）（e_noInterface）
。 c：\ program Files（x86）\ Microsoft SQL Server \ 150 \ dts \ binn \ dts.dll 使用 regsvr32 显示成功，但我仍然得到相同的相同错误。
我还尝试使用 microsoft.sqlserver.dtsruntimewrap.dll 使用 gacutil.exe ，仍然没有运气。
有人可以告诉我为什么我会遇到这个错误以及如何解决这个问题。
先感谢您。
I am using SSIS with Visual Studio 2019 for creating and deploying packages on SQL Server 2019. Initially when my package was running on SSDT I deployed it on SSMS Integration server but there was no output.
So, I Checked in Visual Studio 2019: Project -> Project Properties -> Configuration Properties -> General -> Target Version, which was set to SQL Server 2022, So I changed it to SQL Server 2019.
When I tried to run the package again in Visual Studio 2019 I got this error:
Failed to load the package "Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2019.IDTSApplication160'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{037FE238-12C5-4313-AE13-9E116E90ACEA}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).".
I tried registering the C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\DTS.dll using regsvr32 which shows success, but I am still getting the same error.
I also tried registering Microsoft.SqlServer.DTSRuntimeWrap.dll using gacutil.exe, still no luck.
Can someone tell me why am I getting this error and how to solve this.
Thank you in advance.
发布评论
评论（4）
这是解决方法。
taken from https ：//marketplace.visualstudio.com/items？itemName = ssis.sqlserverintegrationservicesprojects＃：〜：text = ssis％20 execute％20package，设置％20to％20to 20false 。
here is the workaround.
taken from https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects#:~:text=SSIS%20Execute%20Package,set%20to%20false.
在更新SSIS Projects 4.0之后，我的VS 2019遇到了同样的问题。如果可能的话，请卸载此版本并安装最新的常规可用性（GA）版本3.16，可以在此处下载：
https://marketplace.visualstudio.com/items?itemname=ssis.sqlServerIntegrationsProjectsprojectsprojectsprojectsprojects
https://ssis.gallerycdn.vsassets.io/extensions/ssis/sqlserverintegrationservicesprojects/3.16/1645603822968/Microsoft.DataTools.IntegrationServices.exe
它解决了问题，降级后您可以在64位运行时运行。
I had the same problem with my VS 2019 after update to SSIS Projects 4.0. If possible, uninstall this version and install the latest general availability (GA) version 3.16, which can be downloaded here:
https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects
https://ssis.gallerycdn.vsassets.io/extensions/ssis/sqlserverintegrationservicesprojects/3.16/1645603822968/Microsoft.DataTools.IntegrationServices.exe
It solved the problem, you can run in 64bit runtime after downgrade.
我只更新了SSIS扩展3.16至4.0。我有同样的错误。您应该从右键单击项目更改配置属性 - ＆gt;属性 - debugging- run64bitruntime-＆gt;设置为false。
之后，当我想启动VS时，我得到了此警告'../ Visual Studio 2019.Lnk并排配置不正确。我通过修复控制面板上的SQL Server集成服务项目解决了问题。
I have only updated SSIS extension 3.16 to 4.0. I got same error. You should change configuration properties from right click project ->properties->debugging->Run64bitRuntime->set to false.
After that when i want to initiate VS, i got this warning '../Visual Studio 2019.lnk side by side configuration is incorrect'. I resolved the problem through repairing of SQL Server Integration Services Projects on Control Panel-->Programs and Properties.
由于VS的提示，我在更新Microsoft数据工具集成服务与扩展之后遇到了同样的问题。升级是v4.0尚不可用的v4.0。
https：//marksetplace.visalstplace.visalstudio.com.comemnemnemessssissississississemenemenemenemenemenememenemenemementecrint
在该页面上，它指出“版本3.16是最新的通用可用性（GA）版本，不支持目标服务器版本SQLServer2022。”在那里，您会找到v3.16的链接。
卸载v4.0，鉴于该v4.0最近发布的方式可能仍在您的下载文件夹中，否则使用Extension Manager。然后下载并安装3.16。请注意，卸载和复古安装都非常慢。
没有重新启动，我打开了项目和v.4.0失败的软件包，第一次毫无问题地运行。
希望这对某人有帮助。
I had the same problem start after updating Microsoft Data Tools Integration Services VS extension because of prompt by VS. The upgrade was to v4.0 which is not yet generally available.
https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects
On that page it states that "Version 3.16 is the latest general availability (GA) version, which does not support target server version SqlServer2022." There you will find a link to v3.16.
Uninstall v4.0 which, given how recently it was released, is probably still in your downloads folder, otherwise use Extension Manager. Then download and install 3.16. Be warned, both the uninstall and retro install were extremely slow.
Without a reboot, I opened the project and the package that failed with v.4.0, ran first time without problem.
Hope this helps somebody.