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.
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 ...