Copy Activity in Azure data factory do not copy multi line text in sql table maintaining the line breaks.

Question

I am using copy data activity from CSV to SQL. In CSV I have a field with multiline string in csv for e.g.
Refer attachment

But when I run the pipeline in SQL I an seeing the data in a single line like 1 Eastlawn Alley 8528 Coolidge Trail 0133 Oak Valley Park 9660 Sloan Crossing.

The field in CSV is an address field for which I need to break the multi line string to different fields in SQL which I will be doing using another pipeline. But when I am copying data its not coming as multi line string in SQL table.

Answer 1

This question has been answered by me on MSDN.

The text had the Line breaks. These line breaks are visible only when result is set to text format in SSMS.

https://social.msdn.microsoft.com/Forums/en-US/1f0a1e83-30c3-4789-96c3-c92bdc579a1b/copy-activity-in-azure-data-factory-do-not-copy-multi-line-text-in-sql-table-maintaining-the-line?forum=AzureDataFactory

---

If the response helped, do "Accept Answer" and upvote it

• Vaibhav