alt
Advertisement
Online Training
Career Series
Exforsys
Exforsys arrow Tutorials arrow SQL Server 2005 arrow SQL Server Integration Services
Site Search


SQL Server Integration Services
Article Index
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 Component

.

.

.

.

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-Oracle10g-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. 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 >
Sponsored Links
© 2008 Exforsys.com
Joomla! is Free Software released under the GNU/GPL License.
Page copy protected against web site content infringement by Copyscape