• 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