xml to sql 2000 table

[jgn1013]

Pretty new to xml so if you could please point me in the right direction. I'm getting an httpwebresponse from a remote website in a xml format. I would like to either do a openxml stored procedure insert into a table or read through an xml file and insert data to a table. TIA

My xml files looks like this:

<xml_response server="USVSTG01" version="1.21.03" code="0000" result_msg="SUCCESS">
<et_get_next_trans request_id="1195133906828" code="0000" result_msg="SUCCESS">
<usv_transmission id="33076">
<employee_record employer_cd="035420" ssn="011111111" src="ELECTRONIC" lang="EN" svc="I9" event="EMP_NEW">
<emp_info>
<first_nm>JOHN</first_nm>
<mi />
<last_nm>TESTER</last_nm>
<maiden_nm />
<ssn>011111111</ssn>
<dob>1981-01-04</dob>
<hire_dt>2009-01-12</hire_dt>
<dot />
<location_id>035420</location_id>
<address>
<address_1>1405 PEACHTREE RD</address_1>
<address_2 />
<city>ATLANTA</city>
<state>GA</state>
<postal_cd>30346</postal_cd>
</address>
<phone />
<email />
</emp_info>
<dhs>
<case_num />
<usv_status>USV_PRIMARY_TO_SEND</usv_status>
<as_of_date>2009-01-12</as_of_date>
<closure />
<status_descr>Sending verification data to DHS</status_descr>
</dhs>
</employee_record>
</usv_transmission>
</et_get_next_trans>
</xml_response>