Linda_Wang thanks for the reply. I have tested with copy activity the XML column mapped as string and the error is same as previous to this release
The XML column from the JSON file is attempting to insert into an XML datatype in Azure SQL DB
Operation on target Copy data1 failed: ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=XML parsing: line 1, character 55, unable to switch the encoding,Source=.Net SqlClient Data Provider,SqlErrorNumber=9402,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=9402,State=1,Message=XML parsing: line 1, character 55, unable to switch the encoding,},],'