We will not use the Configure Error
Output??¦ option at present.
4. Click on the button OK in the Data Conversion Transformation Editor
window after making the above changes.
Step 5: Adding and Configuring an OLE DB
Data Destination
Adding an OLE DB Destination to Canvas
1. Drag and drop an OLE DB Destination item from the Data Flow
Destinations group on to the Data Flow page of the Canvas.
Establish a Path from Data Conversion Data Flow
Transformation to OLE DB Data Destination
1. Establish a path from the Data Conversion component to the OLE DB
Destination component.
2. Right-click the Data Conversion object in the Data Flow page and choose the
Add Path drop-down menu item, and configure the Data Flow window that
shows up so that From: points to Data Conversion and To: points to OLE
DB Destination using the drop-down handle.
??? ??? ??? ???
Chapter 10
[ 169 ]
3. When you click on the OK button (shown in the previous screenshot), you
will display the Input Output Selection window. Configure the window so
that the Output: points to Data Conversion Output and the Input: points to
OLE DB Destination Input using the drop-down handle. After this, click on
the OK button on the Input Output Selection window.
Now you will review the Metadata of this path segment from the Data
Conversion component to the OLE DB Destination component.
4. Right-click this path segment and choose Edit??¦. In the Data Flow Path
Editor window, click on the Metadata on the left to display the following
read-only window (only a part of this is shown).
Pages:
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128