Reject truncated and overflow data.

Select this option in the target instance Properties tab when you want the Integration Service to write truncated data to the reject file.

Update override.

Override the default UPDATE statement using the SQL Editor in the target instance Properties tab.

Table name prefix.

Specify the owner of the target tables in the target instance Properties tab.

Pre- and post-session SQL.

You can enter pre-session SQL commands for a target instance in a mapping to execute commands against the target database before the Integration Service reads the source. Enter post-session SQL commands to execute commands against the target database after the Integration Service writes to the target.

Target table name.

You can override the default target table name.