XSD Question

[ticatac]

Hi

I'm relatively new to XML and I'm trying to write an XSD to load into ETL so that the generated output will be in the correct format for the system the data needs to go to.

I've managed most of it but am a little stuck with the following and how to write the definition for it:
<CustomInformat ion>
<ColumnValue name="grde">IMC</ColumnValue>
<ColumnValue name="hrs">37.50</ColumnValue>
<ColumnValue name="loc">LON</ColumnValue>
<ColumnValue name="no">99999</ColumnValue>
<ColumnValue name="cur_sts">RSCE_CS_ALC</ColumnValue>
</CustomInformati on>

The items in italics are standard, but the items in bold are the data coming from the database.

My problem is that I just don't have enough experience of writing XSD's to know how to write the definition for the ColumnValue elements, so any help given would be much appreciated.

Thanks in advance.

[Dököll]

Get an example here: http://www.w3schools.com/schema/schema_example.asp

Let us know if you have questions...Wel come.