Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,346 questions
Azure ADF copy activity not generating carriage return '\r' as row delimiter
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
While writing to file through ADF copy activity the file doesn't have carriage return with row delimiter set as default '\r\n'. Any help to add carriage return will be appreciated.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2023-02-13T22:32:27.0833333+00:00 Hello Anonymous Thanks for the question and using MS Q&A platform.
You did share what is the output of copy activity you are getting and what is that you are expecting. Can you also please share as to what is the input to the copy activity?
This will help us understand the ask better. Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2023-02-17T19:37:02.2033333+00:00 Hello @Anonymous , We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help . Thanks Himanshu
Sign in to comment
Sign in to answer