Parse XML to SQL Server

I have a script that is pulling data from HDC in XML. The format of the response is basically as follows (some deletions for security)

- <Item>
  <ItemID>340663905322</ItemID>
  <ViewItemURLForNaturalSearch>http://product.half.ebay.com/Harry-Potter-and-the-Sorcerers-Stone-Jill-Daniels-Hardcover-</ViewItemURLForNaturalSearch>
  <Location>Vienna, VA</Location>
- <Seller>
  <FeedbackScore>28</FeedbackScore>
  </Seller>
  <CurrentPrice currencyID="USD">5.49</CurrentPrice>
- <Storefront>
  <StoreURL>http://shops.half.ebay.com/d4ree_W0QQsellerZd4ree</StoreURL>
  <StoreName>d4ree</StoreName>
  </Storefront>
  <Country>US</Country>
  <HalfItemCondition>BrandNew</HalfItemCondition>
  <SellerComments>Brand new item still in original plastic wrap. Ships fast!</SellerComments>
  </Item>

Is there a program (most prefeably a FREE one) that will allow me to parse the XML into a SQL Server database? If so would it be possible to parse only selected data. For example if I wanted the price of the book but not the country. Or would I be able to do something like put the condition in one table and the price in another or would everything have to go in the same table?
Start Free Trial