question

rjford11 avatar image
rjford11 asked

Fix XML Parsing Errors

We have automated process to load in XML files. About 3% of these won't parse due to various badly formed XML.

I.E.

"XML parsing: line 1, character 4674, duplicate attribute"

"XML parsing: line 1, character 51236, equal expected"

Is there a way in SQL Server to fix these errors in the XML and then reload them?

xml
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.