how to split one column to 2 columns using scriptcomponent based on comma(,)

See more:

SSIS

my table called names like....,sno int,name varchar(30)
1 sri,thatiparthi
2 vasu,vemula
3 rao,t

my output like
id | name| surname
1 sri thatiparthi
2 vasu vemula
3 rao t
using ssis not sqlserver ..how to use script task or any?

please tell me how to do above task using script component or script task please provide c# code