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?