• The DTS can identify two fields from the source to be written to the Execution Log. 
• A Rejected Row table can be created from within the DTS to write any source record rejected by the target application. 

Set Source Key And Source Name In DTS

1. Open the TIBCO Scribe® Insight Workbench.
2. Open a DTS.
3. Click the Configure Source button.
4. Make sure you have a Source entity configured.
5. Click the Source Keys button on the lower left of the window. 
6. In the Source Key Fields window click the button with the ellipsis (…) to display the Source Key Builder window.
7. Select the Source Key from the table fields.  This Source key should be the unique Identifier for the record. 
8. Click OK.
9. For the Source Name field click the button with the ellipsis (…) to display the Source Name Builder window.
10. Select the Source Name from the table fields. The Source Name Field should be a human readable field.  This is most useful when the Key field is a system assigned values such as a GUID.  These two fields will be written to the Execution Log.  See Specifying A Source Key And Name in the Insight help for more information.
11. Click OK on the Source Name Builder window.
12. Click OK on the Source Key Fields window.
13. Click OK on the Configure Source window.

Configure A Rejected Row Table 

1. Open the TIBCO Scribe® Insight Workbench.
2. Open a DTS.
3. Click Run > Edit Settings. 
4. Click the Rejected Source Rows tab.
5. Enable Output Rejected Source Rows. Do not change the database. If the rejected row table is created in the SCRIBEINTERNAL database, then the rejected rows can be viewed from the Execution Log. 
6. In Table/File Settings, select one of the following options:
   • Always append rejected rows to the same table - enter the name for the table in the Table field. 
   • Always create a new table for rejected rows - enter the prefix for the table name in the Prefix field. 
7. Click OK.