To start with, all the fields in the Flat File Connection Manager Editor
window are empty.
4. Type in a name for the connection manager and an appropriate
description of your choice. The name chosen for the connection manager is
"Ch4TxtManager" and the description, "Chapter4's Flat File Manager".
5. Now click on the button Browse??¦ to locate the Chapter4.txt created in the
C:\ drive after navigating to the C: drive.
If you have not created a text file to start with, in the Open window for
locating the file, you can create the file, and immediately click on the created
file (but then you have to add the Column headers as shown previously).
This gets added with default file format information (Locale, CodePage,
Head Row Limiter and Head rows to skip), as shown in the following
screenshot.
6. Also place a check mark in the Column names in the first data row, as we
chose to add Column names.
7. Choose items related to Format the same way the text file was formatted in
mini-step 26 (comma delimited, headers rows not skipped).
8. When you click on the Columns in the left-hand side, you see displayed the
column names you created earlier in the Chapter 4.txt file.
Transferring Data to a Text File
[ 96 ]
9. Click on the OK button on the Flat File Connection Manager Editor.
This adds the connection manager, Ch4TxtManager to the Connections
Managers' page in the Canvas.
10. Right-click the Flat File Destination component and choose Edit??¦.
Pages:
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81