Importing special characters into SQL Server from XML source

Question

Hi,

I'm having great difficulty dealing with special characters in XML source file when importing them in SQL server via a data flow task. I have the following character 'ú' in one of my xml files (which is correctly defined in the XSD file as a string)  and it results in the following error: -

[XML Source [24575]] Error: The component "XML Source" (24575) was unable to process the XML data. Invalid character in the given encoding. Line 6279, position 23.

Is there any way I can import such a character or alernatively redirect the record to another table via an Error Output. Any help would be greatly appreciated. Thanks.

Mike

Answer 1

Check this which gives a structured approach to importing xml files with special characters dealing with encoding issues as well.

---

http://btsbee.wordpress.com/