Since you have the comma as a delimiter and the address data contains a comma as well, you are bound for trouble.
SSIS will think a new column has started.
You either choose a decent delimiter (something like |$|) or you use text qualifiers.
id , name , address
1 , "abc" , "chennai,tamilnadu"
In that case, you also need to be sure that " never occurs in the data itself, or you have issues again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP