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

zzzz 20 Reputation points

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.

User's image

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,435 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 27,926 Reputation points Microsoft Employee

    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

    0 comments No comments