Operations

Insert the source record into the target.

Update an existing record in the target with information from the source record. If the target record is not found, log an error condition.

Delete a record from the target. If the record does not exist in the target record, log an error condition.

You cannot create a data link on a Delete step.

Perform an Insert/Update operation in a single step, if the connection supports it. If the target record exists, update the record. Otherwise, insert the record.

An insert, update, upsert (if supported) or delete value in the source will determine the operation performed on the target.

When selecting this option, also select the source field that contains the operation indicator.

Insert the source record into the target. If the insert fails, update the target record with no error. Insert failures are typically caused by violating the target table’s unique index.

Update the existing record in the target with information from the source record.

If the target record does not exist, the update fails without logging an error condition and the information is inserted into the target as a new record.

Uses lookup links to find rows in the target database. Does not modify any data on the target database. Rather, a SQL statement like the following is formed:

SELECT <all target table fields> FROM <target table> WHERE <target fields match source data — as defined by the lookup links>.

If a row or rows are found, the values for the first row retrieved are placed in internal buffers. The values are also used to provide values for foreign keys in later steps.

Seek operations can return zero rows, one row or more than one row.

Search for a record and monitor the result of the search. Results that can be acted on are:

• Failure (database error, etc.)
• Success with zero rows affected or found
• >Success with 1 row affected or found
• Success with more than one row affected or found

You cannot create a data link on a Seek step.