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

Govinda Kumar 1 Reputation point
2020-05-04T07:12:21.883+00:00

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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,643 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,631 Reputation points
    2020-05-08T13:58:21.857+00:00

    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
    0 comments