'SSIS Data flow task (SQl -> CSV) data formatting issue

In SSIS, I have a data flow task which uses a data flow task to get data from SQL and save it in CSV file( using flat file connection manager).

In this, I have a column which will give me values like (case1 and case 2 are just for reference.)

Case 1: 2333,376677

Case 2: E37777,77777

In first case, I am not getting the , in Csv. It is giving me 2333376677.

In case 2, it is working fine.

In connection manager, I am delimiting with text qualifier as ".

Any suggestions on how to fix this?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source