最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

script task - SSIS DtsDebugHost.exe automatically creates unnecessary bindingRedirects in the local DtsDebugHost.exe.config - St

programmeradmin6浏览0评论

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?

与本文相关的文章

发布评论

评论列表(0)

  1. 暂无评论