This can be accomplished either by double-clicking the component in the
Toolbox or a drag-and-drop operation.
2. Right-click Character Map and from the drop-down menu choose Add Path.
This opens up the window, Data Flow, which allows you to establish a data
flow path, and displays the "From:" location as Character Map.
3. Click on the drop-down along "To:", which shows both the Excel Destination
as well as the DataReader Source.
4. Choose the Excel Destination and click OK to the screen.
This opens up the Input Output Selection window that shows the available
output and input windows. The Output window is empty whereas the input
shows Excel Destination Input. The path should connect from the Character
Map to the Excel Destination Input.
5. Choose the above options and click on the OK button on this screen.
You will see a green line connecting the Character Map Data Flow
Component to the Excel Destination, as shown in the next screenshot.
Alternately, the process of establishing the path can be simplified by just
picking the green dangling line from Character Map and dropping it onto the
Excel Destination object on the Data Flow page. As seen in the next screenshot,
you may also edit the path after it is created by right-clicking on this
green line and choosing the Edit??¦ drop-down menu item.
Chapter 5
[ 107 ]
Step 6: Configuring the Excel Destination
Component
The data is on its way through the path, represented by the green line in the previous
step.
Pages:
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89