Configuring the Transfer Database Task.
Building the BI project and executing the package.
??? ??? ???
Chapter 15
[ 229 ]
Step 2: Creating a BI Project and Adding
a Transfer Database Task
1. Create a Business Intelligence Project Ch 15 and rename the default name of
the package.
The default name was changed to TransferDb.dtsx in this exercise.
2. Drag and drop a Transfer Database Task from the Control Flow Items
group in the Toolbox to the Control Flow Page on the Canvas.
Step 3: Configuring the Transfer Database Task
1. Right-click the Transfer Database component in the Control Flow Page on
the Canvas and from the drop-down choose Edit??¦
The Transfer Database Task Editor opens displaying the Name and
Description properties of the General tab.
2. Change the Name and Description properties to suitable ones for this exercise.
The name was changed from Transfer Database Task to Copy a database
from SQL 2000 to SQL 2005 and the description from Transfer Database
Task to Copying the Pubs database from 2000 to 2005 Server as shown in
the following screenshot (partial view shown).
Package that Transfers a Database from One SQL Server to Another
[ 230 ]
3. Click on the Databases list item on the left.
This opens the window where information about the two servers involved in
the transfer must be provided. The main details to be furnished are shown in
the partial view, as shown in the next screenshot.
There are three main areas that need to be considered.
Pages:
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165