Chapter 4
[ 91 ]
1. Click on the location (shown in the previous screenshot) and from the
drop-down list, choose the connection manager you configured in Step 2,
displayed as shown in the following screenshot.
2. Select this connection manager by clicking on this item.
3. Next, click on the Component Properties tab to open the properties of the
DataReader component.
Here you will notice that this requires an SqlCommand (empty for now), as
shown in the following screenshot.
4. In the Sql Command field, click on the ellipsis button along its side.
You will pop open a text editor where you can type in your Sql Command.
You may also directly type-in the Sql Command chosen for the exercise in
this field, as in the next mini-step.
Transferring Data to a Text File
[ 92 ]
5. Type in "Select CustomerID, CompanyName, Address, City, PostalCode
from Customers".
6. Before you move onto the next tab, click on the Refresh button.
You may create the text file using a File System Task (we'll be discussing
that in the later chapters)
7. Click on the Column Mappings tab.
This will open the Column Mappings page, showing the columns that are
the available outputs from the DataReader.
The column mappings shown connecting the available external columns to
the available output columns can be independently modified, although no
such modification will be made. This is just to illustrate the flexibility you
have in modifying column mappings.
Pages:
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78