Loading XML data into database

Summary

How to load a CSV file into database that contains a field with XML data

Content

Hi,

I'm hoping you can help. I have a CSV file containing textual and XML data, as the example below demonstrates. I need to load this into a table in my database. A copy of the file is also attached.

292+|Next-Door Bike Store+|279+| <StoreSurvey xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"><AnnualSales>800000</AnnualSales><AnnualRevenue>80000</AnnualRevenue><BankName>United Security</BankName><BusinessType>BM</BusinessType><YearOpened>1996</YearOpened><Specialty>Mountain</Specialty><SquareFeet>21000</SquareFeet><Brands>2</Brands><Internet>ISDN</Internet><NumberEmployees>13</NumberEmployees></StoreSurvey>+|A22517E3-848D-4EBE-B9D9-7437F3432304+|2014-09-12 11:15:07.497000000&|
294+|Professional Sales and Service+|276+| <StoreSurvey xmlns="