Chapter 10
[ 165 ]
8. Alter the Output Column rows by adding a letter "e" to the beginning of each
row. For example Name is changed to eName etc.
At present, we will not configure the error output as this is a simple contrived
example that will not produce any error.
9. Click on the OK button in the above window to complete the Excel
Source configuration.
Step 2: Adding a Data Conversion Data Flow
Transformation
1. Drag and drop a Data Conversion item from the Data Flow Transformations
group in the Toolbox onto the Data Flow Page of the Canvas.
This adds a Data Flow item to the Data Flow Page of the Canvas.
On Using a Data Conversion Data Flow Transformation
[ 166 ]
Step 3: Establishing a Path from Excel Source
to Data Conversion Data Flow Transformation
1. Right-click the Excel Source and from the drop-down choose Add Path.
2. Establish a path from Excel Source component to the Data Conversion
component using the interactive path connection GUI.
Complete the Data Flow path window that shows up so that the From To:
points to Excel Source and the TO: label points to Data Conversion. Use the
drop-down in the "To:" to make this happen.
3. Click on the OK button and complete the Input Output Selection window
that gets displayed so that the Output: points to Excel Source Output and
the Input: points to Data Conversion Input.
4. Click on the OK button in the Input Output Selection window.
The Excel Source and the Data Conversion item are connected by a path, as
indicated by a thin green line connecting them.
Pages:
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126