2. Right-click DataReader Source. From the drop-down menu choose,
Add Path.
This opens up the window, Data Flow, which allows you to establish a data
flow path, and displays the "From:" location as DataReader Source.
Data Transfer to an MS Access Database
[ 114 ]
3. Click on the drop-down along "To:".
This will show both the OLE DB Destination as well as the
DataReader Source.
4. Choose the OLE DB Destination and click on the OK button..
This opens up the Input Output Selection window that shows output and
input windows available. You need to choose the appropriate ones. The path
should connect from the DataReader Source to the OLE DB Destination
Input (this will be the default), as shown in the following screenshot.
5. Choose the above options, click on the OK button on this screen.
You will see a green line connecting the DataReader Source to the
OLE DB Destination.
Step 5: Configuring the OLE DB Destination
Component
The OLE DB Destination also requires a connection manager. The OLE DB
Destination connects to an MS Access Database file on your hard drive using the
connection properties defined in a connection manager.
1. Right-click OLE DB Destination and from the drop-down menu click on
Edit??¦.
You get a Microsoft Visual Studio (Standard Edition 8.0.50727) warning
("This Component has no available...").
2. Click on the button Yes, to this warning.
This opens the OLE DB Destination Editor with a list on the left-hand side
and three OLE DB related drop-down boxes on the right.
Pages:
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95