Configuring a DB Data Sink Update Component

Add and configure a DB Data Sink Update component to your project.

1. Drag the DB Data Sink Update component onto the Design window.
2. Add the connection parameters for the target database.
3. Specify the destination table to which 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 the transformation results to an existing table or add a Destination table based on existing ports in the project.

   To add a table based on an existing port structure, skip this step.

4. Click Finish.
5. 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.

• Updating Port Structure with Database Changes
  Apply database changes to the port structure of components.
• Loading Data at IN-port to a Database or a Text File
  Use the Flush Buffer option to write out the buffered rows to the target.