Export To Data Lake - csv - Double Quote String Delimiters

(0) Share

Report

Posted on by JtimorACC360

I'm attempting to implement the Export to Data Lake from D365 to Data Lake storage.

So far I've been able to create about 26 base tables from D365 to Azure synapse as External Tables and query them with out any problems. There are two base tables where I've seen double quotes inside an address or name column, causes the external reference to that base table to fail with a "Could not find a delimiter after string delimiter."

data looks like so:

So the data exports correctly it seems but the external table reference will not see this as a simple column between the comma delimiters.

Below is the File Format I'm using for the External Table:

Feel I should open a ticket with Microsoft

Any thoughts?

I have the same question (0)

All responses (1)

Answers (0)

Community member 2 on at

Like (0)

Report

Hi.

How do you fix it?

I have the same issue at the moment when We export data from D365 and for sample has inches in the data like this 14"5 and receive issues when try to import into the data lake.

Hopefully you can share the solution.

Was this reply helpful? Yes No