5. Click and choose the Flat File Destination.
6. Now click on the OK button in the Data Flow window.
You will see a green line connecting the DataReader Source to the Flat File
Destination, as shown in the following screenshot.
Alternately, the process of establishing the path can be simplified by just
picking the green dangling line from DataReader with the mouse, and
extending it to touch the Flat File Destination object on the Data Flow page.
Transferring Data to a Text File
[ 94 ]
As seen in the following screenshot, you may edit the path after it is created by
right-clicking this green line and choosing Edit??¦ from the drop-down menu.
Step 5: Configuring the Flat File Destination
Component
The data is on its way through the "path" represented by the green line in the
previous step. The Flat File Destination also, requires a connection manager.
The Flat File Destination connects to a text file on your hard dive using the
connection properties defined in a connection manager.
1. Create a text file, Chapter4.txt, (for this exercise using Notepad) in the
C:\ drive.
At present, the Chapter4.txt is empty.
2. Go ahead and type in a line of text for the column headers separated by
commas, as shown in the next paragraph:
CustomerID, CompanyName, Address, City, PostalCode
3. Right-click a clear area inside the Connection Managers' page and from the
drop-down choose, New Flat File Connection??¦.
Chapter 4
[ 95 ]
This opens the Flat File Connection Manager Editor, as shown in the
following screenshot.
Pages:
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80