Configuring a DB Data Sink Insert Component

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

1. Drag the DB Data Sink Insert component onto the Design window.
2. In the Database Configuration window, add the connection parameters for the target database.
3. Specify the appropriate properties.
4. Select or enter the destination table.

   You can write to an existing table or add a table based on existing ports in the project. To add a table based on an existing port structure, skip this step.

5. Click Finish.

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