4. Now that the connection manager and the table are chosen, click on the
Mappings list item on the left.
This opens the Mappings between the View on the Oracle 10G XE and the
Available Destination Columns.
5. Accept this default mapping and click on the button OK on the above editor
to complete the SQL Server Destination configuration.
Package to Copy a Table from Oracle XE
[ 212 ]
Step 7: Building and Executing the Package
1. Build and execute the package.
The program runs and after a while the source and destination components
turn green indicating that it was a successful run. Open the OracleTable table
in the SQL Server to verify that data has been transferred as shown below.
It is important to note that the correct provider for the SQL Server
destination is the Microsoft OLE DB provider for SQL Server.
Summary
In this chapter the steps involved in transferring the data in a Table in the Oracle 10G
XE server to a table in the SQL Server 2005 , were described. Installing and reviewing
the objects in the Oracle 10G XE's hr database was also looked at.
Web Service Task to
Convert Miles to Kilometres
Primarily, a web service is a web application (a software program) that lends
itself easily for exchange of data with other web applications. In doing so, it helps
businesses to share assets with customers, venders, etc., and allows them to leverage
data in disparate systems.
Some of its features are:
It adheres to Open Standards like XML, SOAP, TCP/IP, HTTP, etc.
Pages:
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154