CSV comma issue in Sink

Question

Hi,
My source file is having a column value like Naperville, IL
Please note that the value Naperville, IL is a single column value.
I want this value to be written in a csv file.
When I try to write this data in csv (sink), the column value is getting separated like Naperville\, IL
and single column becomes as two columns (one col value as Naperville\ another one has IL).
Can you please let me know how I can handle this comma issue?
Please find the attachment for the sink setting.

Thanks.

Answer 1

Hi @Gowri Shankar ,

There is an option "Quote character" for the DelimitedText DataSet. Probably you have "no quote character" selected there. If that's the case, please change the option and it will work (see the screenshot below).

Please let me know if this helps. If it does, please don't forget to "accept the answer" and "up-vote"! Thank you!