The rows that had errors will be redirected to the error output, the red line
between components in the Canvas.
3. Click on the button OK on this window.
Step 6: Adding and Configuring a Recordset
Destination for Displaying Errors
You add a Recordset Destination to monitor the error and details of errors. Adding
a Recordset Destination has been described in earlier chapters.
1. Drag and drop a Recordset Destination from the Toolbox.
2. Drag the dangling red line from OLE DB Destination that represents the
error and connect it to the Recordset Destination.
This establishes a path for the error to flow to the Recordset Destination.
3. Double-click the Recordset Destination.
This opens up the Advanced Editor for Recordset Destination.
4. In the Component Properties page, provide a variable (herein called DCerr)
and associate the Recordset Destination with this variable.
5. Choose the input columns to the Recordset Destination in the tabbed page
Input Columns of the Advanced Editor for Recordset Destination.
In addition, you add Data Viewers to the completed Canvas, one in the path of the
OLE DB Destination and the other in the path of the Recordset Destination.
Chapter 10
[ 173 ]
Step 7: Building the Project and Testing
the Package
1. Build the project and execute the package as described in the previous
chapters.
The program cranks up and you will see all the five rows passing from
Data Conversion object to the OLE DB Destination object as shown in the
following screenshot.
Pages:
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131