XML column splitting in ADF copy activity
Prapul Kumar Dongari
116
Reputation points
Hi team , I have table in SQL which contains XML column ,while i was copying data from SQL to ADLS (.csv format) the xml column data is getting splitted into new rows.
note : ADF sink dataset settings are as follows
escape character : doublequote
quote character : doublequote
XML column format is shown in screenshot:
please help me with solution
Sign in to answer