This will display the DataConvert connection manager in the OLE DB Destination
Editor window as well as adding an icon to the Connection Manager's window of
the Canvas.
Displaying the Table to which the Data will
be Inserted
Click on the drop-down along the Name of the table or view: label on the OLE DB
Destination Editor's window and choose Access Destination table from the
drop-down, as shown in the next screenshot. At this point, if you click on Preview
button, you will see the table fields but no data.
Chapter 10
[ 171 ]
Column Mappings
1. Click on the Mappings list item on the left of the previous figure. Follow
guidance in the figure and associate the input / output columns for all
columns (only shown for one).
Handling Data Loading Errors
Looking at the DataCnvrt.XLS sheet entries and the MS Access Database table
AccessDestination table column data types, it is easy to see that there will be errors
in loading the data. In this section, we will configure the errors to be ported to a
Recordset Destination item.
1. Click on the Error Output list item on the left. This opens the window shown
in the next screenshot where you can indicate how errors are to be handled.
On Using a Data Conversion Data Flow Transformation
[ 172 ]
There are three options (as shown in the screenshot) displayed in the
drop-down list in the error column.
2. In the Set this value to selected cells:, click on drop-down and select
Redirect row.
Pages:
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130