The XML page cannot be displayed due to £ sign
I came across something simple and annoying earlier this week.
I had XML file as source with a string called "Room Hire £200". For one reason or the other I couldn't load the file via SSIS. I couldn't see anything wrong with the file. I try to open the file via Internet Explorer and I got the following error message.
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh <BLOCKED SCRIPTlocation.reload()> button, or try again later.
An invalid character was found in text content. Error processing resource ‘file:///C:/MAB/SourceFiles/Micros/EmReferencedat...
<MenuItemName>Room Hire
To fix this problem I had to put the following statement on top of the XML document.
<?xml version="1.0" encoding="Windows-1252"?>
Ref - http://discuss.joelonsoftware.com/default.asp?joel.3.394399.24
Thanks
Sutha