Best way XML File handling bullet point •

Question

For an XML file I am creating I have data that contains a bullet • what is the best method for handling this in xml data? It opens in an XML editor and reads fine, but I cannot import the file via SSIS, I get an error regarding this point.

<xmldata>• Bullet</xmldata>

Renders fine, but cannot import with SSIS.

Answer 1

The data you have received is not well-formed XML. It may have < and > in it, but it is not XML. The program that generated it is broken and needs to be fixed.

In particular, is the bullet the only character that will cause you problems? A program that puts one garbage character into your "XML" will likely put others in, since it doesn't seem to know what valid XML looks like.

Answer 2

Escape it:

•