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.
929 questions
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.
Charles
For this reason, csv file in sink copy data by splitting into different columns and rows.
Attached is the image of output file
{count} votes
-
KranthiPakala-MSFT 35,261 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
Sign in to comment
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.