Import XML to MS SQL Database

Hello,
I have a problem with importing xml file(UTF-8 encoding) to MS SQL Database to table column as Data Type “XML”

I use “XML reader” and “Database Writer” (Database connector)

ERROR Database Writer 0:48 Execute failed: java.lang.Exception: Error while adding row #2 (Row0), reason: XML parsing: line 1, character 38, unable to switch the encoding

Where is the problem ? Could you help me?

Database Connector settings
jdbc:sqlserver://;Database=;integratedSecurity=true

Thanks
Martin

Hi there!

Have you tried changing encoding? Check this out:

Br,
Ivan