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" target="_blank" rel="nofollow"). Downloading and installing Oracle 10G XE is fully described in the tutorial (http://www.devshed.com/c/a/Oracle/Experience-the-Possibilities-with-Oracle10g-Express-Edition" target="_blank" rel="nofollow").

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. This opens the Services window as shown in the next screenshot where you can scroll down to the Oracle XE Server. Here, you can click on the hyperlinks in the left to stop, restart or pause the service.

Another convenient way is to use the shortcuts installed when the Oracle 10G XE is installed, as shown in the next screenshot. Some times the short-cuts could get displaced and it is a better practice to look up in the Services folder. The shortcut also gives you access to the home page of the database.

Next Page: SSIS - Using the Object Browser