To work with XML attributes in addition to element values, first toggle the Show Attributes setting in the bottom of the mapping designer frame. When enabled, the designer will display any attributes detected as a child of the element the attribute belongs to.
All XML attributes are named with a ‘@’ prefix (the ‘@’ symbol is not a valid character in an XML element name). This ‘@’ character is purely for display, and will be stripped away when reading or writing actual attributes.
Reading XML Attributes from the Source
Once the Show Attributes toggle is enabled, any attributes in the XML source will be displayed as nodes in the mapping designer. These values can be dragged-and-dropped onto the destination just like any other node. These nodes will show the ‘@’ prefix indicating they are XML attributes and not XML elements.
Writing XML Attributes in the Destination
Destination templates that include XML attributes will display the attribute nodes (as children of the element they belong to), and these nodes can be mapped just like any other value.
To add new attributes to a destination template, right-click the element node that the attribute should belong to and select New Attribute from the right-click menu.
Note when creating new attributes that the attribute name should always begin with the ‘@’ prefix (this prefix character will not actually be included in the output XML).