Hi adf001 ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query here.
It seems like the issue you are facing is related to the way the XML output is being processed by the ADF COPY activity. It seems the COPY activity treats the XML output as a text file and splits it into multiple rows based on the delimiter specified in the sink dataset.
To avoid this issue, kindly try using the "Binary" format for both source and sink dataset instead of xml and "DelimitedText".
Although the source dataset is of binary type, you can point it to the xml file . Similarly, in sink create the binary dataset and give the filename with .txt extension.
This will ensure that the XML output is treated as a binary file and would not split into multiple rows. The XML output should be written to the sink dataset as a single binary file.
Hope this helps! In case you still face same issue, kindly share the sample data so that I can repro the same at my end. Kindly accept the answer by clicking on
Accept answer button. Thankyou