sql server - How can I split a comma-delimited value into multiple rows? -

i have table1 query string pulls following remote table whereby mykeys comma-delimited list:

table1:  mykeys varchar, mycount int, mycomment varchar 

i need update local 2008r2 table based on:

table2: split somehow - mykeys int, mycount int, mycomment varchar 

currently, have ssis package pulls information , creates local table. i've seen answers using functions feed select statement (e.g. mykeys), nothing includes multiple fields e.g. (mykeys, mycount, mycomment).

maybe make ragged right or fixed length destination , have comma text qualifier?