Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  .NET Inside SQL Server (2005)  HTML in XML

Author  Topic  PBs Starting Member 1 Post Posted - 2009-11-12 : 13:55:10 Hi, I have an XML . The XML consist of a description tag. The description tag consist of numerous HTML tags . I need to populate a table in sql server 2005 from this XML. But because of the HTML , I am having problems in doing so . Is there a way that I can escape the HTML tags from the <description> tag in XML dynamically? I am using SSIS to populate the table . Right now I am manually escaping the HTML but want to do it dynamically . Below is the sample XML . <?xml version="1.0" encoding="UTF-8" ?> <Ads> <Ad> <AdId>1004314</AdId> <Title>2003 Honda. 70K miles. $9,000.</Title> <Description><div align="justify"> 2003 Mercedes. 70K miles. $9,000. Brand New Tires. <br /> </div> </Description> </Ad> </Ads>