For this tutorial, no modifications are made.
10. Click on the OK button in the above window.
This completes the configuration of the DataReader which brings five columns from
the SQL 2005 Server.
Step 4: Adding a Character Map
Transformation
The Character Map transformation is described in Chapter 1, but here you will
be experimenting with this transformation. The transformation manipulates the
text string that is coming to it and outputs the manipulated string. For example,
in the screenshot we have just seen above, the CompanyName has mixed case.
Using this transformation, we will capitalize all the characters that appear in the
CompanyName column before it is written to an Excel File??”Alfreds Futterkiste
will become ALFREDS FUTTERKISTE, etc.
1. Drag and drop a Character Map data flow item from the Data Flow
Transformations Group in the Toolbox onto the Data Flow page of
the Canvas.
Chapter 5
[ 103 ]
2. Right-click on the DataReader Source and from the drop-down click on the
Add Path menu item.
3. From the displayed window, Data Flow, choose Character Map for the To:
field as shown.
4. Click OK in the above window, and the following window is displayed.
Here, you need to indicate the output from this component, from the
drop-down shown.
5. Choose DataReader Output Source from the drop-down.
At present, you will not be dealing with any errors in this tutorial. When you
choose the above option, the OK button gets enabled.
Pages:
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87