Copy activity output multiple line of row record instead of a single record for XML file

Question

i am using copy activity to copy the XML output from my mssql to azure blob storage. I sink the xml output file as a DelimitedText with xml.extension. However, the file break into 4 lines instead of a single line. Any idea why the copy activity break the xml out file into multiple lines? In such case, the xml output file create error due to broken attribute, element.

it breaks to 4 new lines. And azure recognize it as 4 row of record instead of 1 row

Answer 1

Hi adf001 ,

It seems like a duplicate post for this query . Kindly try the solution provided there.

However, looking at the image, it seems the row delimiter for delimited text is not set properly. By default, it's set to:

on read: ["\r\n", "\r", "\n"]

on write: "\n"

Probably the xml contains line breakers (\n) which is taking the further data to the new line.

Kindly try updating it to '> ' and see if it works. Thankyou