SSIS软件包错误更新为VS2019

发布于 2025-01-21 16:43:07 字数 1048 浏览 1 评论 0原文

更新到VS2019后，我在SSIS软件包中收到以下构建错误。

'Microsoft.sqlserver.dts.runtime.dtsgenericexception：由于错误0xC00CE504而无法加载XML”，“名称启动了一个无效的字符。第14行，第1列”'。

我已经浏览了XML查看软件包，第14行是构建版本，我看不出无效的字符在哪里。我仍然可以在VS2015中加载同一项目，并按预期执行。我已经凝视了很长时间，试图找到错误的位置。还有其他人经历过吗？

我正在运行带有SSIS Designer版本15.0.2000.180的Visual Studio版本16.11.11。 SSIS项目扩展版3.16。

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
   DTS:refId="Package"
   DTS:CreationDate="9/4/2020 8:48:51 AM"
   DTS:CreationName="Microsoft.Package"
   DTS:CreatorComputerName="STEVE-SALOWIT"
   DTS:CreatorName="MORLEY\ssalowitz"
   DTS:DTSID="{5F2F7616-8292-449F-AE0E-ACAEBDA52423}"
   DTS:ExecutableType="Microsoft.Package"
   DTS:LastModifiedProductVersion="15.0.2000.180"
   DTS:LocaleID="1033"
   DTS:ObjectName="ESG Workday_Report_Import"
   DTS:PackageType="5"
   DTS:VersionBuild="278"
   DTS:VersionGUID="{5B1F0D3E-1A82-48BA-A786-6FD0822E7871}">
   <DTS:Property
     DTS:Name="PackageFormatVersion">8</DTS:Property>

原文

After updating to VS2019 I have been receiving the following build error in an SSIS package.

'Microsoft.SqlServer.Dts.Runtime.DtsGenericException: Failed to load XML due to error 0xC00CE504 "A name was started with an invalid character. Line 14, Column 1"'.

I have looked through the XML for the package and line 14 is the build version and I don't see where an invalid character would be. I can still load the same project in VS2015 and execute as expected. I have stared at this for quite some time trying to find where the error might be. Has anyone else experienced this?

I am running Visual Studio version 16.11.11 with SSIS designer version 15.0.2000.180. SSIS Project Extension version 3.16.

<?xml version="1.0"?>
<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
   DTS:refId="Package"
   DTS:CreationDate="9/4/2020 8:48:51 AM"
   DTS:CreationName="Microsoft.Package"
   DTS:CreatorComputerName="STEVE-SALOWIT"
   DTS:CreatorName="MORLEY\ssalowitz"
   DTS:DTSID="{5F2F7616-8292-449F-AE0E-ACAEBDA52423}"
   DTS:ExecutableType="Microsoft.Package"
   DTS:LastModifiedProductVersion="15.0.2000.180"
   DTS:LocaleID="1033"
   DTS:ObjectName="ESG Workday_Report_Import"
   DTS:PackageType="5"
   DTS:VersionBuild="278"
   DTS:VersionGUID="{5B1F0D3E-1A82-48BA-A786-6FD0822E7871}">
   <DTS:Property
     DTS:Name="PackageFormatVersion">8</DTS:Property>

分享到QQ

分享到微博