When you add a relational target to a mapping, you can configure the following properties:
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.
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.
You cannot configure these properties in the Target Designer.