Selecting a Target Destination involves selecting a target file for an appropriate database. The designer has a few choices to make in this section.
Create a new table as the destination for the data?
If so, select the first radio button "Specify a new table for
the target...", select the database and owner, then specify the
new table name.
Use an existing table as the destination?
If so, select the second radio button "Select an existing table
to user for the Target..." and then use the drop down to choose
the table.
If an existing table is selected, does the table structure need
to change for the transform?
If so, the target table can be dropped and recreated with the new structure
by selecting "Drop and re-create the existing target table"
Track only changes to the source (For use with Microsoft SQL
Server Integration Services)?
In this case a target table is not necessary, select the third radio
button "Create a change data capture synchronization..."
and only changes in the source will be tracked. See the section
on Change Data Capture
transforms for more information.
Click Next to proceed to Step 3: Sync