6. Click on the OK button in the above window.
This establishes the path from the Data Reader Source to the Character Map
data flow component. The path is established but it still needs configuration.
7. Right-click the Character Map component and from the drop-down menu
choose, Edit.
Transferring Data to a Microsoft Excel File
[ 104 ]
This opens the Character Map Editor, as shown in the following screenshot.
Place a check mark for the Company Name column.
If the default as shown in the above were to be chosen, then an extra column
will be added to the output. We choose the option In-place change from the
drop-down.
8. Click on the cell, New Column, under Destination in the above window.
From the drop-down choose, In-place change.
Chapter 5
[ 105 ]
9. Click just below the Operation list-header and from the drop-down list
choose Upper Case as shown in the following screenshot.
The output alias remains the same as it is an in-line change.
10. Click on the button OK in the pick-up list and to the OK button in the
Character Map Transformation Editor.
This completes the Character Map configuration.
Transferring Data to a Microsoft Excel File
[ 106 ]
Step 5: Adding an Excel Destination and
Establishing a Path to It from the Character
Map Data Flow Component
In this step, we will add an Excel Destination. We will then establish a path from the
Character Map to Excel Destination.
1. Add an Excel Destination component from the Data Flow Destinations
group in the toolbox to the Data Flow page.
Pages:
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88