Listado con el nombre y descripción corta de las operaciones que se pueden realizar en el destino de un DTS (Scribe data translation specification).
Insert – Source record is inserted into the target.
Update – Information from the source record updates an existing record in the target.
Update / Insert – Information from the source updates an existing record in the target. If the target is not found, the update fails without logging an error condition and is followed by an insert into the target as a new record.
Insert / Update – the source record is inserted into the target. If the insert fails, tipically due to the violation of the target tables unique index, no error is reported and an update will occur.
Seek– Looks for a record and monitors the result of the seek. The results that can be acted on are:
- Success with zero rows affected or found,
- Success with 1 row affected or found,
- Success with more than one row affected or found
Execute – Used only for stored procedures
Delete – A record in the target will be deleted. If the target record is not found, an error condition is logged.