I Have a problem when i am trying to export "XML data with UTF-8" to the XML data type column for a table in the database from a Excel File using a SSIS Package.This is the Error : "XML parsing: line 1, character 38, unable to switch the encoding" .
I got a solution that, we need to change the UTF-8 to UTF-16 and the XML data got inserted into the database properly.
Then, we try to insert the same "XML data with UTF-16" into the database using a simpe insert query then it throws the error :"
XML parsing: line 1, character 39, unable to switch the encoding
". But when i try to insert the same "XML data with UTF-8".
Why is this happening and is there any way we can insert "XML data with UTF-8" into the XML data type column in the database via SSIS package. I don't want to change the encoding from UTF-8 to UTF-16. Please help
Moved byEdward ZhuThursday, August 02, 2012 2:41 AM (From:SQL Server Reporting Services, Power View)