Configuring a DB Data Sink Insert component

  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. See the “DB Data Sink Insert properties list” for specific field requirements.

  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. If you want to add a table based on an existing port structure, skip this step. See Adding a Destination table for additional information.

  5. Click Finish.

  6. Specify any other optional properties in the Properties window.