finding the invalid character

Question

In my SSIS project in Visual studio 2019, I am receiving this error.

An error occurred with the following error message: "System.Xml.XmlException: ' ', hexadecimal value 0x03, is an invalid character. Line 44, position 4.

I believe I have found the correct line with the following query in Microsoft SQL Server Management Studio

SELECT id, name, ROW_NUMBER() OVER (ORDER BY name) AS RowNumber
FROM MyTable

However, after checking the whole row I couldn’t find the invalid character.

How can I find position 4 on line 44 in Microsoft SQL Server Management Studio?

Answer 1

I found the invalid character, by selecting all the records in the table, and saving them as an CSV file.

Then I open the CSV file in Notepad++ and set show symbols to show all characters.

Then I was able to find the record with the invalid character.

Thank you all for the help

Answer 2

As Viroel suggests, the error message does not refer to a row in your table. Rather the error message refers to a specific XML document in your table.

You may be able to find the document with this query:

SELECT * FROM tbl
WHERE charindex(nchar(3), cast(xmldoc AS nvarchar(MAX)) COLLATE Latin1_General_BIN2) > 0

Answer 3

Hi @GanSea ,

Could you please share the components in your ssis package?

Could you please share the example results of the query "SELECT id, name, ROW_NUMBER() OVER (ORDER BY name) AS RowNumber FROM MyTable" ?

The following link will be helpful:
HEXADECIMAL VALUE 0X03 is an invalid character

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.