In the drop-down menu
with the Tables chosen, you will be able to see the details of the Table, EMPLOYEES,
as shown in the next screenshot.
Chapter 13
[ 203 ]
Step 1: Creating a BI Project and Adding
a Data Flow Task
This process has been described a number of times in the previous chapters.
1. Create a BI project Ch13. Change the name of the default package name to
OraTo2k5.dtsx. Drag and drop a Data Flow Task from the Control Flow
Items group in the Toolbox to the Control Flow page on the Canvas.
An instance of the Data Flow Task will be added to the Canvas to the
Control Flow page.
Package to Copy a Table from Oracle XE
[ 204 ]
Step 2: Adding an OLE DB Source and
Configuring it to Connect to a Local Oracle
10G XE Server
1. Drag and drop a OLE DB Source from the Data Flow Sources group in the
Toolbox to the Data Flow page of the Canvas.
2. Right-click an empty area in the Connection Managers' page in the Canvas,
and from the pop-up menu choose New OLE DB Connection??¦
(The detailing of what to do next is abbreviated as this has been dealt in an
earlier chapter). This opens the Configure OLE DB Connection Manager's
window. The left-hand area shows all existing data connections under Data
Connections: label and the right-hand area shows the details of the data
connection you choose on the left under the label Data connection
properties. On the right side, below you will find the New??¦ button to
create a new OLE DB Connection.
Pages:
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150