Drag DB Data Sink Update onto the Design window.
On the Database Configuration window, add the connection parameters for the target database.
See the “DB Data Sink Update properties list” for specific field requirements.
Specify the Destination table where you want to write the transformation results. You can click the Destination Table icon to select the table, or manually enter the name of the table in the Destination Table field.
You can write to an existing table or add a table based on existing ports in the project. If you want to add a table based on an existing port structure, skip this step. See Adding a Destination table for additional information.
Click Finish.
In the Properties window, click the Key icon to select the columns of the Destination table that identify the records to update.
You must specify a Destination table before you can select a key, and you can select multiple key columns. This is a logical selection, not related to any underlying indexes in the database schema.
Specify any other optional properties in the Properties window.
