ansaurus

Question

Best way XML File handling bullet point •

Answer 1

+1 A:

Escape it:

&#8226;

Yuval A 2010-03-16 13:20:42

-1: that's not a valid entity for XML.

John Saunders 2010-03-16 13:22:25

oops... fixed...

Yuval A 2010-03-16 13:26:05

Answer 2

A:

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.

John Saunders 2010-03-16 13:33:49

You are right there could be other garbage characters, I am writing the file via SSIS is there a good way to parse through a file to remove invalid characters or escape them via SSIS, maybe using a script task?

2010-03-16 13:46:10

@dbengals: you could do that sort of thing, but it doesn't address the problem: why is the source program sending you that garbage? Maybe it thinks it's sending good data? Maybe the data actually means something? You need to try to find out what the garbage means before escaping or removing it.

John Saunders 2010-03-16 14:08:42

ansaurus

tags:

views:

answers:

Best way XML File handling bullet point •

related questions