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.
TableA 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:
Append: Rows are simply appended to the table.
Replace: All existing records in the table are deleted before any new rows are added.
Update: Existing rows are updated where the value of a particular column (which is set in the dialog) matches the import row. If there is no match then the import row is ignored. ( Rekall simply generates an SQL update statement and executes for the values in the import row. Hence, the question of whether zero, one or more rows in the table are changed is just a function of the server database )
Replace/Insert: This is the same as Replace, except that if no rows are updated then the import row is appended to the table.
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.