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

shanucnu8888 1 Reputation point
2022-02-04T11:59:01.733+00:00

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

Basic document flow

171325-untitled.png

"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

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,330 questions
{count} votes