The UNC name of the share (\\Computer 1\PubsData) will appear in the
Network File Share boxes.
9. Click on the OK button on the Source Database Files window.
10. Now change the Method to DatabaseOnline.
Chapter 15
[ 235 ]
This inserts the database name for the destination as shown in the next screenshot as
well as the DestinationDatabaseFiles related information.
Configuring the Destination Database
The destination database is on the same machine as the Visual Studio on which the
package will execute.
Again, the DestinationDatabaseFiles item value generated by this task can be error
prone and needs to be rectified. The reason is that the Transfer Database Task does
not correctly identify the SQL Server to which the transfer is to be made when a
plurality of SQL Servers are installed on the machine. The reader may refer to the
following article (http://www.aspfree.com/c/a/MS-SQL-Server/Transferring-a-
Database-Using-the-SSIS-Designer/) by the author for more detailed explanation.
1. Click on an open area along the line item DestinationDatabaseFiles.
This opens the Destination Database Files window, as shown in the
following screenshot. You can see that this is not the SQL Server chosen for
data transfer.
Package that Transfers a Database from One SQL Server to Another
[ 236 ]
The correct destination files reference, for data going into the SQLExpress
server on this machine should be the following (note the highlighted database
server name):
"pubs.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169