XML 任务错误消息十六进制无效字符 [英] XML Task error message hexadecimal invalid character

问题描述

我正在开发一个 SSIS 包，以将数据从 XML 文件添加到现有的 SQL Server 表.我已经完成了几个类似的项目，但是在这个 XML 文件中，我从 XML 任务和数据流任务之间的数据流选项卡中得到错误:

I am developing a SSIS package to add data from an XML file to an existing SQL Server table. I have completed several similar projects, but on this XML file I am getting the error from the Data Flow tab between the XML Task and Data Flow Task:

Error: 0xC002F304 at XML Task, XML Task: An error occurred with the following error message: 
"'', hexadecimal value 0x15, is an invalid character. Line 28, position 54.".
Error: 0xC002928F at XML Task, XML Task: Property "New Source" has no source Xml text; 
Xml Text is either invalid, null or empty string.
Task failed: XML Task
Warning: 0x80019002 at zSTU_TS_Element: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "zStu_TS_Element.dtsx" finished: Failure.

你知道我该如何解决这个问题吗?

Do you know how I can fix this?

这是它从我的 XML 文件中引用的行:

This is the line it is referring to from my XML file:

<z:row c0='12' c1='80' c2='2006-04-17' c3='539' c4='1M2083N4N5N6N75800901110 11 '/>

推荐答案

没有错.字符U+0015 Negative Acknowledge"(0x15，ASCII 21)是一个不能放入 XML 1.0 文件的控制代码.您拥有的 XML 文件格式不正确(因此不是真正的 XML 文件)；尝试在任何其他 XML 阅读器(例如 IE)中打开它，你应该得到同样的错误.

It's not wrong. The character ‘U+0015 Negative Acknowledge’ (0x15, ASCII 21) is a control code which cannot be put in an XML 1.0 file. The XML file you have is not well-formed (and hence not really an XML file); try to open it in any other XML reader (eg. IE) and you should get the same error.

您需要使用文本编辑器从文件中删除该字符，并查看生成它的任何损坏源.

You'll need to hack that character out of the file using a text editor, and have a look at whatever broken source produced it.

(不幸的是，我们看不到这里发布的那个字符，因为它是一个通常不可见的控制代码，无论如何 StackOverflow 都会过滤掉.然而，一个好的文本编辑器应该能够显示某种标记，它在那里.错误中的列号表明它位于 c4 属性值的开头，尽管这不一定可靠.)

(Unfortunately we can't see that character posted here, as it's a typically-invisible control code which StackOverflow filters out anyway. A good text editor should, however, be able to display some sort of marker that it's there. The column number in the error suggests it is at the start of the c4 attribute value, though this isn't necessarily reliable.)

这篇关于XML 任务错误消息十六进制无效字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！