In order to follow the steps indicated, you will need a source and
a destination??”the source, data extracted from an Oracle 10G XE server and the
destination, loading this to MyNorthwind database on the SQL Server 2005. You also
need to establish a path connecting them.
Package to Copy a Table from Oracle XE
[ 200 ]
Hands-On Exercise: Transferring a View
from Oracle 10G XE to an SQL Server
2005 Database
The following are the major steps in this exercise:
Installing and viewing objects on the Oracle 10G XE.
Creating a BI project and adding a Data Flow Task.
Adding an OLE DB Source and configuring it to connect to a local Oracle 10G
XE Server.
Configuring the OLE DB Source.
Adding an SQL Server Destination and configuring its connection manager.
Establishing a path from the OLE DB Source to the SQL Server Destination.
Configuring the SQL Server Destination Component.
Building and executing the package.
Oracle 10G XE Server
The Oracle 10G XE is available as a free download from Oracle's website (http://
www.oracle.com/technology/software/products/database/xe/index.html).
Downloading and installing Oracle 10G XE is fully described in the tutorial (http://
www.devshed.com/c/a/Oracle/Experience-the-Possibilities-with-Oracle-
10g-Express-Edition).
Starting and Stopping the Oracle 10G XE Server
With the Oracle 10G XE installed, you should be able to configure its stop / start
mode using the Window's Services. From Start you can get to the Services folder
after clicking Control Panel, Administrative Tools, and Services in succession.
Pages:
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148