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 ] 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.