admin管理员组

文章数量:1399939

I have:

  1. Microsoft Visual Studio Community 2019, version 16.11.45.
  2. SQL Server Integration Services (SSIS) Projects 4.6.
  3. A project in SSIS with the target server version SQL Server 2019. The problem is that when I debug a package in Visual Studio, DtsDebugHost.exe starts. It creates a file DtsDebugHost.exe.config in a folder like "..\Microsoft\Microsoft SQL Server\150\SSIS\AppLocalConfigs\16.11.35826.135_9a164a51". This file is used for assembly binding.

In addition to system redirects from the configuration templates, like

<dependentAssembly>
        <assemblyIdentity name="Microsoft.SqlServer.WebServiceTask" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
        <bindingRedirect oldVersion="15.0.0.0" newVersion="15.100.0.0"/>
        <codeBase version="15.100.0.0" href="C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Tasks\Microsoft.SqlServer.WebServiceTask.dll"/>
      </dependentAssembly>

it also creates other assemblies like

  <dependentAssembly>
        <assemblyIdentity name="System.Text.Json" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-99.9.9.9" newVersion="4.0.1.0" />
        <codeBase version = "4.0.1.0" href = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\..\..\MSBuild\Current\Bin\System.Text.Json.dll" />
      </dependentAssembly>

I am using a specific version of the System.Text.Json (9.0.0.0) is in the script task component and everything builds perfectly. However, errors occur when executing the package, because redirects occur in the DtsDebugHost.exe.config file.

Yes, I can edit this DtsDebugHost.exe.config file manually. But it's not very transparent, and the location depends on the target version, VS version, and build. And these settings are easy to lose, as they are not tied to the package.

I can't find information about how DtsDebugHost creates the DtsDebugHost.exe.config file. Can I change this process?

本文标签：

版权声明：本文标题：script task - SSIS DtsDebugHost.exe automatically creates unnecessary bindingRedirects in the local DtsDebugHost.exe.config - St 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744240463a2596764.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。