Specify Archive Criteria
Specify the archive criteria for the table. Queries can be created for multiple columns in the selected table by using "AND" or "OR" between each individual query.
Select ... From
This box displays the archive query. Queries must be a valid SQL query, starting with "WHERE" and can either be entered directly, or by using the Columns and Operators.
The table the query is performed against. By default this is populated with the selected Archiving Table.
This box lists all the columns for the Table Name. Double-click a column to configure a query for it.
The list of operators to use in the query. Double-click an operator to add it to the query.
Select this box to have the archived rows deleted from the source database after a successful archive.