How To Map One Xml Node Attribute To Table Column And Other As Value

Hi All,

I have to do this work in ssis.
I have to read a xml and that xml have node like this

<Attribute Name="apDlBhUtil" SF="F" Value="5"/>

<Attribute Name="apDlBhUtilThresh" SF="F" Value="2"/>

<Attribute Name="apUlBhUtil" SF="F" Value="12"/>


I have a table which contaion column name are values of name attribute. there are 50 to 60 attribute in xml.

table script is

create table Attribute
(

apDlBhUtil int,
apDlBhUtilThresh int,
apUlBhUtil int
)

now would please tell me how i can insert related value in my table.

my result would be like

apDlBhUtil apDlBhUtilThresh apUlBhUtil

5 2 12

Thanks in advance.
Manish Jain