What would be the best way to split a sql string from one column into many?

I have a column which contains html, within this there are many <h3> tags containing headings.

i.e.
row 1
<h3>overview</h3>gjbvjjkvbjkvv<h3>Details</h3>hcvhjchjcj<h3>cost</h3>cccc

I need to split the string based on the h3 tags into the correct columns of a new table.

In addition i need to support incorrectly titled tags such as the overview may sometimes be referred to as summary.

row 2
<h3>summary</h3>ghghcvcvv<h3>Details</h3>hcvhjchjcj<h3>cost</h3>cccc


I need to do this for a result set of 3k rows.

I have SSIS and sql server 2010 along with VS2008 and 2010 at my disposal.