Using the Destination Component
After
Establishing a Connection to the data source, add the TIBCO TDV destination component to the workflow to load data into TDV.
Writing to TDV in a Data Flow
Follow the steps below to connect to TDV and update data.
1. In the SSIS Toolbox, drag the TIBCO TDV destination component into the Data Flow Task.
2. Connect the output of a source component to the TIBCO TDV destination component.
3. Double-click the TIBCO TDV destination component. The TIBCO TDV Destination Editor dialog will display.
4. In the Connection Managers menu, select an available TIBCO TDV connection manager, or create a new instance if one is not already available.
5. In the "Use a Table" option, select the table to update.
6. Select the data manipulation action. See below for more information on each action.
7. On the Mappings tab, configure the mappings from source to destination. By default, outputs from the source component will automatically be mapped with the same name as the columns in the table you selected. You can further update these selections.
Command Execution
When you execute the data flow, the component will execute one of the following operations to update the destination table.
Insert
The component will take the mapped values and attempt to insert the data as new rows into the table. By setting the OutputKey property to True in the destination component's properties, you can retrieve the results of the insert in the error output of the component with the 'Redirect row' error behavior.
Update
The component will attempt to update an existing row based on the primary key provided. The primary key column must be mapped, and it must not be null. By setting the OutputKey property to True in the destination component's properties, you can retrieve the results of the update in the error output of the component with the 'Redirect row' error behavior.
Upsert
The component uses the primary key to decide if a row is to be inserted or updated. If the primary key column is mapped and it is not null, the component will attempt to update an existing row based on the primary key provided. If the primary key is not mapped or if it is null, the TIBCO TDV Destination Component will attempt to insert the data as a new row. By setting the OutputKey property to True in the destination component's properties, you can retrieve the results of the upsert in the error output of the component with the 'Redirect row' error behavior.
Delete
The component will attempt to delete an existing row based on the primary key provided. The primary key column must be mapped, and it must not be null.