Step 2 - Selecting a Target Destination
Selecting a Target Destination involves selecting a target file for an appropriate database. The designer has a few choices to make in this section:
1. If you want to create a new table as the destination for the data, select Specify a new table for the target..., select the database and owner, and specify the new table name.
2. If you want to use an existing table as the destination for the data, select Select an existing table to user for the Target... and use the drop down menu to choose the table.
3. If you have selected an existing table and you need to change the table structure for the transformation, you have to drop and recreate the target table with the new structure by selecting Drop and re-create the existing target table.
4. If you're using Microsoft SQL Server Integration Services and wish to track only changes to the source, a target table is not necessary. In this case, select the Create a change data capture synchronization.... See the section on Change Data Capture transforms for more information.