XML attribute name/value pairs

[Peter]

I have an XML file where an element has 2 attributes, type and value. The
type attribute contains the field name, the value attribute contains the
value of the field. How do I make that assignment happen?

Here's what it looks like:
<VehicleAttributes>
<VehicleAttribute type="VehicleType" value="Truck"/>
<VehicleAttribute type="Year" value="2005"/>
<VehicleAttribute type="BodyStyle" value="Cab Chassis" />
<VehicleAttribute type="Make" value="Ford" />
<VehicleAttribute type="Model" value="F-450" />
<VehicleAttribute type="Series" value="Super Duty" />
</VehicleAttributes>

Here's the same thing in a format that my app (SQL Server SSIS) understands.
I had to edit this by hand to support my question:
<VehicleAttributes>
<VehicleAttribute VehicleType="Truck"/>
<VehicleAttributeYear="2005"/>
<VehicleAttribute BodyStyle="Cab Chassis"/>
<VehicleAttribute Make="Ford"/>
<VehicleAttributeModel="F-450"/>
<VehicleAttribute Series="Super Duty"/>
</VehicleAttributes>

The outputs from the VehicleAttribuute element are type and value. I want
them to be VehicleType, Year, BodyStyle, Make, Model and Series. How to do?

[Luuk]

Op 9-4-2010 16:07, Peter schreef:

> <VehicleAttributes>
> <VehicleAttribute VehicleType="Truck"/>
> <VehicleAttributeYear="2005"/>
> <VehicleAttribute BodyStyle="Cab Chassis"/>
> <VehicleAttribute Make="Ford"/>
> <VehicleAttributeModel="F-450"/>
> <VehicleAttribute Series="Super Duty"/>
> </VehicleAttributes>

would this not be easier/better/....?:

<VehicleAttributes>
<VehicleAttribute VehicleType="Truck" Year="2005" BodyStyle="Cab
Chassis" Make="Ford" Model="F-450"/ Series="Super Duty">
</VehicleAttributes>

--
Luuk