SQL Server Integration Services

Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy .

 

 

Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking

Connecting to Microsoft Access, Text Files, Excel Spread Sheets Linking data source and data destination to a task

Transforming data from a source going to a destination Using the scripting support that the IDE provides and event handling

Learning about tasks such as web service and XML, which are new in SQL Server 2005

 

This guide provides a detailed understanding of how tasks are designed by way of an example as well as describing the nuts and bolts that are used in configuring them. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section.

This chapter explains Transferring a View from Oracle 10G XE to an SQL Server 2005 Database.

Package to Copy a Table from Oracle XE

Modern business enterprises have to contend with resources from disparate vendors of databases for many different reasons, that includes historical: new developments in technology; cost concerns; acquisition of resources (M & R), etc. For example, although a large hospital might have its main database using Oracle or SQL Server 2005, the various departments and cost centers may use other products. In these cases, it is important to have the capability of easily transferring objects from one vendor type product to the other. Every database vendor provides a built-in toolset to address the migration of database objects, or whole databases to another vendor type database.

Although this tutorial describes the details of copying a Table from Oracle 10G XE to an SQL Server 2005 database using a SSIS task, you should review an earlier article (http://www.devshed.com/showblog/28087/StepByStep-Guide-to-ImportingData-from-Oracle-XE-to-SQL-2005/" target="_blank" rel="nofollow"), which uses the IMPORT / EXPORT utility to import data from Oracle 10G XE to SQL Server 2005.

In this exercise, we will transfer a Table from the hr database on the local Oracle 10G XE server to the MyNorthwind database on the local SQL Server 2005 using a Data Flow Task. In order to follow the steps indicated, you will need a source and a destination—the source, data extracted from an Oracle 10G XE server and the destination, loading this to MyNorthwind database on the SQL Server 2005. You also need to establish a path connecting them.

Next Page: SSIS - Oracle 10G to SQL Server