• Add a Derived Column transformation to break up column two as you need.

    The expression for column 1 will be something like this:

    SUBSTRING([PersonName/FatherName/RationCardNo],1,FINDSTRING([PersonName/FatherName/RationCardNo],",",1) - 1)

    That will extract all the text from position 1 to the position of the first comma, but not including the comma.

    I'm sure that you can work out the others.