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

shanucnu8888 1 Reputation point

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.


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