The Provider chosen is
the Microsoft OLE DB Provider for SQL Server. You may notice that the (.) format
is used for designating a default SQL Server 2005 installation. This server uses SQL
Server Authentication. After choosing the authentication, you will be able to Select
or enter database name from a drop-down list. In case your server uses Windows
authentication, you don't need to provide the username and password.
Chapter 13
[ 209 ]
Step 5: Establishing a Path from the OLE DB
Source to the SQL Server Destination
This has been described in most of the tutorials , so wont be repeated here.
1. Establish a path from the OLE DB Source to the SQL Server Destination.
The Metadata of the path connecting the source and the destination will
appear as shown in the Data Flow Path Editor window below.
Package to Copy a Table from Oracle XE
[ 210 ]
Step 6: Configuring the SQL Server
Destination Component
1. Right-click the Sql Server Destination component and from the drop-down
click on Edit??¦.
This opens up the SQL Destination Editor displaying the connection
manager configured earlier.
2. Click on the New??¦ button. "Use a table or view:".
This pops-up the Create Table window shown superposed on the SQL
Destination Editor.
Chapter 13
[ 211 ]
3. In the Created Table window, replace the SQL Server Destination by some
name of your own. Here, for this exercise, it is called Oracle Table. Click
on the OK button on the CreateTable window after changing SQL Server
Destination to OracleTable.
Pages:
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153