I am using copy data activity from CSV to SQL. In CSV I have a field with multiline string in csv for e.g.
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.