Hi @Bhaskar-1984 ,
Thankyou for using Microsoft Q&A platform and thanks for posting your question here.
As I understand your issue, you are trying to copy data from AS400 database to .csv file in ADLS. However, there is an issue with the line breaks
You can use derived column transformation in mapping dataflow to replace newline with blank by using the expression:
replace(colName,'\n','')
Note: This functionality is not there in Copy activity .
Kindly check the below image.
For more details, kindly check following resources:
https://learn.microsoft.com/en-us/answers/questions/91071/how-to-remove-line-breaks-from-excel-file-in-adf.html
https://www.youtube.com/watch?v=AW0oHU8MAm8
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on
or upvote
button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how - Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators