Add and configure a DB Data Sink Update component to your project.
Drag the DB Data Sink Update
component onto the Design window.
Add the connection
parameters for the target database.
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.
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.