Adding a Destination Table

You can write the transformation results or inbound data to an existing table or add a destination table based on existing ports in the project. You cannot add a table based on a port structure from the Database Configuration window or Properties window. You must select the port structure in the Design window.

• Writing to an Existing Table
  Write the transformation results to a selected table that already exists.
• Adding a Destination Table Based on Input Port
  Create a new destination table based on input ports for writing inbound data.
• Adding a Destination Table Based on an Existing Port
  Create a new destination table based on existing port for writing inbound data.