Tutorials
SQL Server 2005
SQL Server Integration Services
SSIS - Oracle 10G to SQL Server
SSIS - Using the Object Browser
SSIS - Configuring the OLE DB Source
SSIS - Configuring SQL Server Destination ComponentThe following are the major steps in this exercise:
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").
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