This paper focuses on the advantages of using SQL Server Integration Services (SSIS) to extract data from heterogeneous sources and import data into Microsoft SQL Server for Business Intelligence (BI) analysis and reporting. Oracle Database 10g data is used as the primary data source.
The audience for this paper includes IT professionals, database administrators, and system architects. The reader should have a general understanding of databases and Microsoft SQL Server and Oracle Database 10g. Readers should use the referenced databases on their preferred hardware platform.
Included in This Document