Click on the area shown for making a connection. Click on the drop-down
handle, and from the menu choose New Connection??¦.
5. In the OLE DB Connection Manager that shows up, click on the
New??¦ button.
This opens the Connection Manager window as shown in the following
screenshot. This was the same one we saw in the earlier chapters (Chapter 4,
5). The same choices are used. The connectivity may be tested with the Test
Connection button. Notice that the Provider is the new type, Native OLE
DB\SQL Native Client.
Chapter 7
[ 129 ]
6. Fill in all the details as shown in the previous screenshot. Verify the
connectivity is good by clicking the Test Connection button.
7. Click on the OK button (shown in the previous screenshot).
This brings in LocalHost.MyNorthwind into the Connection textbox.
8. Now click on the next area for choosing the table.
From the drop-down that shows a list of tables choose TestCustomer table,
as shown in the following screenshot.
9. Click on the area near ColumnDelimiter in the Format node, and change
from Tab to {,}, as shown in the following screenshot.
Data Transfer from a Text File using the Bulk Insert Task
[ 130 ]
10. Click on the area shown near File to look for the file created in Step 1.
This reveals a drop-down.
11. Click on the drop-down arrow head and choose New Connection??¦. Accept
the default Existing File.
This opens the File Connection Manager Editor as shown in the following
screenshot.
Pages:
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104