Source SQL Table Have 1 column with tab spaces, unable to copy data to ADLS it shows below.

shanucnu8888 1

Source is SQL:
One of the table contains column as below:

Basic document flow

"Hi Team

We are separated by our margins. Because of margin collapsing, we are separated by the width of one of our margins, not both.

Charles

For this reason, csv file in sink copy data by splitting into different columns and rows.

Attached is the image of output file

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2022-02-08T20:48:54.277+00:00
Hello @shanucnu8888 ,

Thanks for the question and using MS Q&A platform.

To better understand the ask here, could you please provide more details as below:

What is the service that you are using to copy data from SQL to ADLS Gen2? Is it Azure Data Factory or something else?

Appreciate if you could attach a sample source data structure (dummy data) or a clear picture of source data structure and the expected sink data structure.

We look forward to your response.

Thank you
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2022-02-14T22:57:12.88+00:00

Hello @shanucnu8888 ,

We still have not heard back from you. Just wanted to check if you are still facing the issue or need assistance on this? In case If you have already found different solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.