question

GovindaKumar-4356 avatar image
0 Votes"
GovindaKumar-4356 asked LeonLaude commented

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

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.


[1]: /answers/storage/attachments/7911-capture.png


azure-data-factory
capture.png (5.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,


Q&A currently supports the products listed in right-hand pane (more to be added later on).


You can reach the experts in the dedicated Azure Data Factory forum over here:
https://social.msdn.microsoft.com/Forums/azure/en-US/home?forum=AzureDataFactory


(please don't forget to mark helpful replies as answer)


Best regards,
Leon


0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.