O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required