XML & SQL Server 2000

I am new to XML, and could use a little help. I am writing a program that will receive an XML feed, insert that feed in a SQL table, and then process the data. I will have access to a sample XML feed, the schema, and the DTD (none of which I can provide due to that security release I signed). Is there a way to use the schema and/or the dtd to create the tables and stored procedures needed to get the XML into the tables? I understand this is a hard question to answer without seeing the sample files, but what I am looking for is a generic process that I can use to get this going, or even better, a program that will analyze the schema or dtd and generate the SQL statements to create the tables (yes, I am that lazy ;D ).

I think this is going to require SQL Server 2000's OPENXML, but I am open to suggestions if anyone has a better way.

ok I found it...xmlspy can create database structures from schemas, and it can convert DTD's to schemas.

How does XmlSpy handle ampersands within XML fields? I am having issues with ampersands causing my script to crash.

Ampersands are used by the xml parser as entity references, so any ampersands in your info should be converted to unicode &

I normally do this on an ASP page first using vbscript (obviously you'll have to use whatever context you are in) by doing

myString = Replace(myString, "&", "&")