The following are the major steps to be taken in this exercise:
Creating a BI project and adding a Data Flow Task.
Configuring the DataReader's Connection Manager.
Configuring the DataReader Source.
??? ??? ???
Data Transfer to an MS Access Database
[ 112 ]
Adding an OLE DB Destination and establishing a path from the DataReader
Component.
Configuring the OLE DB Destination Component.
Incorporating a Data Viewer to monitor data flow.
Step 1: Creating a BI Project and Adding a
Data Flow Task
1. Create a business intelligence project Ch 6 as described in Chapter 2 or
Chapter 3.
2. Change the default name of the package to TableToAccess.dtsx.
3. Drag and Drop a DataReader Source from Data Flow Sources group onto
the Data Flow page.
Step 2: Configuring the DataReader's
Connection Manager
Configuring the connection manager for a DataReader source that connects to the
local SQL Server 2005 has been described in detail in the previous chapter (steps
2 and 3 of Chapter 4). After this step, you should be seeing a connection manager
Localhost.MyNorthwind.sa in the Connection Managers page.
Step 3: Configuring the DataReader Source
1. Right-click the DataReader Source and choose Edit??¦ from the
drop-down menu.
Advanced Editor for DataReader Source, the connection manager gets
displayed.
2. In the Advanced Editor for DataReader Source, click on the Connection
Manager tab and choose Localhost.MyNorthwind.sa, created in the
previous chapter.
Pages:
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93