Forum Discussion

Torin78's avatar
Torin78
New Member
2 years ago
Solved

Importing CSV File

Hi, i am trying to import a csv file such: 345,Fernandez,"{id:4r34,add:calle,ape:feraa}"   I´ve imported the file with SQL Server Management Studio and it Worked perfect, putting this {id:4r34,add...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Yes i think that i am doing properly.

    Importing with Management Studio it works fine.

     

     

     

Torin78's avatar
Torin78
New Member
2 years ago

Hi Yilingo Zhou i dont want to parse the json i want to store the whole json in a filed, but the pipeline break the field when it find a ",".

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Torin78 ,

Here are some steps you can follow:

1. Define the Source Dataset:
In ADF, create a dataset for your CSV file.
Ensure that the Column Delimiter is set to , and the Quote Character is set to ".
2. Use Data Flow:
Create a Data Flow in ADF.
Add a Source transformation and connect it to your CSV dataset.
In the Source settings, ensure that the Quote Character is set to ".

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes i think that i am doing properly.

    Importing with Management Studio it works fine.