Database Reference
In-Depth Information
One issue is that these fields don't contain the data you want to load. You want to
load the derived columns instead. There a couple ways to correct the mapping, but I
like dragging and dropping the fields I
want
mapped to the columns where I wish them
to be mapped. Since mapping is, by definition, field-to-field, the existing (auto-) map-
pings will be overwritten by the new. Try it! Drag the
strRecordType
field from
Available Input Columns to the
RecordType
cell in Available Output Columns. See?
The old mapping is updated. Now map
strName
to
Name
and
itnValue
to
Value
,
as shown in
Figure 7-8
:
Figure 7-8
.
Overwriting the auto-mappings
Click the OK button; you're finished configuring the OLE DB destination adapter.
Press the F5 key to execute the SSIS package in the SSDT debugger. Hopefully, your
Data Flow task succeeds and appears as in
Figure 7-9
.
Figure 7-9
.
A successful data flow!
Search WWH ::
Custom Search