Copier Destinations

File

The settings for a file destination are pretty well the same as for a file as source. The only difference is the error options, where Ignore excess is replaced by Pad with nulls, whereby if the source does not provide enough values, then nulls (empty strings) are used.

Table

A table as a destination has similar settings as a table as source. However, there are a set of options that control how rows are imported:

XML

XML destination writes ouput to a file, but in XML format.

The root document element is named according to the Main document tag setting; each row is then a child element of the root element, and is named as the Row element tag settings.

Values are ouput either as attributes of the row elements, or as text in value elements which are children on the row elements. The attribute name or value element names respectively are set in the Fields area of the dialog, along with the choice of attribute or element.

The Set from table button can be used to choose a server database and table on which to base the set of fields.