Right-click the OLE DB Source component on the canvas and bring up the
OLE DB Source Editor, as shown in the next screenshot.
The OLE DB Connection Manager is the recently created connection manager
xe.hr. As we are accessing a Table from the database, the default for the Data
access mode: is acceptable as it is.
2. Click on the drop-down for the Name of the table or view:
This field reveals all the accessible objects on the hr database on the Oracle
10G XE Server.
Package to Copy a Table from Oracle XE
[ 206 ]
3. Choose the view, "HR"."EMPLOYEES", we saw earlier in the object browser
of this database.
Chapter 13
[ 207 ]
4. Click on the Preview??¦ button to see the Table that is being used from the
Oracle 10G XE through this connection.
This brings up a Microsoft Visual Studio warning page as shown in the
following screenshot. Ignoring this warning and continuing by clicking on
the OK button on the window with the warning will show all the columns of
the EMPLOYEES in the Preview Query Results window.
5. Click the OK button.
Step 4: Adding a SQL Server Destination and
Configuring its Connection Manager
1. Drag and drop an SQL Server Destination component from the Data Flow
Destinations group, from the Toolbox onto the Data Flow page of
the Canvas.
2. Following a procedure similar to the OLE DB Connection Manager, configure
a Connection Manager (LocalHost.MyNorthwind) for the SQL Server
Destination.
Package to Copy a Table from Oracle XE
[ 208 ]
The following screenshot shows the final screen of the Connection Manager window,
after the connectivity test using the Test Connection button.
Pages:
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152