This opens the Flat File Destination Editor, displaying the recently
configured connection manager (it is also possible to configure a new
connection manager starting from here as well). In Microsoft programs,
there is more than one way of carrying out a task.
11. Click on the Mappings list item on the left side of this window, as shown in
the following screenshot.
Chapter 4
[ 97 ]
On the right-hand side, you see how the columns are mapped to the
destination columns. Here, you see the association between the columns
that are coming into the Flat File and those that are being written to
the destination.
12. Place your mouse on any of the columns (Input Column or
Destination Column).
You will see a tool-tip text window displaying the information for that
particular columns, as shown for StreetAdd column.
13. Click on the OK button in this screen and you are done.
Step 6: Build and Execute the Package
1. Yes, click on the Build menu item.
2. Now right-click the package file TableToText.dtsx in the Solution
Explorer, and from the drop-down choose Execute Package.
The program starts up and after a while the data flow components change to
green, after turning briefly to yellow at first (red means failure). You will also
see that 92 rows were transferred (you will see "92 rows" by the side of the
green path line connecting the source and the destination).
You will see messages in the Output window with the final line displaying
successful execution of package.
Pages:
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82