If the csv file is created with Notepad program, the data should be like: 1,ramu,ameerpet,hyd.

– quote, then the Flat File Connection Manager can load the csv file data correctly. In this scenario, we can directly change the Text Qualifier option to a single double So the data should be like: 1,ramu,”ameerpet,hyd”.

If the csv file is created with Excel program, the column that contains comma would be surrounded by double quote marks.