Error while using import CSV to databse V5 smart service

Hi Experts,

We are using Microsoft SQL databases

Have requirement to import CSV file to database where the CSV file is comma(,) separated and its value has comma as well

Sample:

"POL_NO","POL_TYP","DESC"

"12345678","ABC","LMNO, PQR(abcd, efg, hij.) XYZ"

When i configured Import CSV to Database V5 for above requirement, getting below error while runing

java.lang.RuntimeException:java.io.IOException: (line 179) invalid char between encapsulated token and delimiter

Kindly suggest how to resolve this issue

Thanks

Meena

  Discussion posts and replies are publicly visible