Now, you can save your searches to easily repeat search requests.
Saving a search is as easy as 1-2-3:
1. Perform a search. The Search Results page opens. 2. Optionally, choose filters or update your search term. 3. Click Save Search.
You can access saved searches from a list next to the Search field that appears on every page. Saved searches store the search term and any search filters that you apply.
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.
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.
You cannot configure these properties in the Target Designer.