Database Reference
In-Depth Information
Figure 10-16.
Choosing the target SQL Server table
■
You also can create the connection manager and the database table on the fly while configuring the destination
component by clicking on the respective
New
buttons as shown in Figure
10-16
.
Note
Mapping the Columns
After you set up the connection manager and select the destination table, navigate to the
Mappings
tab to ensure
the column mappings between the source and the destination are correct, as shown in Figure
10-17
. Click on
OK
to
complete the configuration.