Forum Discussion
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...
Yes i think that i am doing properly.
Importing with Management Studio it works fine.
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.
Yes i think that i am doing properly.
Importing with Management Studio it works fine.