You can modify, individually, by
clicking on the connection you want to modify, and then making a right-click
to display the drop-down shown in the inner window.
Chapter 4
[ 93 ]
In the last tab on this editor, Input and Output properties, you can add/
remove items from the External Columns, the Output Columns, and the
DataReader Error output. For this exercise no modifications are made.
8. Click on the OK button in the above window.
This completes the configuration of the DataReader that brings five columns
from the SQL 2005 Server.
Step 4: Adding a Flat File Destination and
Establishing a Path from DataReader Source
In this step, we will add a Flat File destination component to the Data Flow page.
1. From the Toolbox menu, drag and drop the Flat File Destination
component, under the Data Flow Destinations group, onto the Data
Flow page.
2. Now right-click DataReader Source, 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 DataReader Source.
3. Click on the drop-down To:, which shows both the DataReader Source as
well as the Flat File Destination.
4. Choose the Flat File Destination and click the OK button.
This opens up the Input Output Selection window, which shows the output
and input windows available. You need to choose the appropriate ones.
The path should connect from the DataReader Output to the Flat File
Destination Input.
Pages:
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79