Strings Embedded with Commas enclosed with " "

Flat File... Comma Delimiter....Strings Embedded with Commas enclosed with " "....

Eg :

Id,Name,Address,Amt
123,"Ramesh Babu","2/16,KAD Road,GZB",50000

Solution :

In the Delimiters Section of Flat File Definition Set the properties like :

Column....... ,

Row..........{New Line}

Text.........." (By default this is None}