Transferring a Database Using the SSIS Designer - Configuring the Source Database
(Page 6 of 7 )
The Action that will be taken is to Copy a database. It can be changed to Move if needed. The default method is DatabaseOffline. Change this to DatabaseOnline. The source database name is TestBase.
Once the connection to the server is established, the handle which will appear when you click on an empty area by the side of the SourceDatabaseName should allow you browse and pick up the database you want to transfer as shown. Since it is online, the source file area gets filled with the location of the source files and is grayed out.
SSIS Designer Behaving Badly
As you might have observed, by configuring the source, the destination gets automatically configured. Let's assume that this is okay (this needs to be assumed because this did not work as implemented). We do not have a destination database as yet, so there is no question of overwriting a file. We may take the default option. This completes the configuration of the task.
Proceed and Execute
Let's execute this package by right clicking the package and clicking on the Execute shortcut in the drop-down. The Transfer Database Task control turns yellow and the Progress tab shows up. When you click on the Progress tab it shows your progress as shown in the next picture. Finally the package failed to execute.
When you look at the output window, which shows the output from the debug process, you will see the following detail. It's not a very helpful message, I'm sure you'll agree. It looks like the SSIS Package finished successfully, but the task failed. This reminds me of the old joke about how "the operation was a success, but the patient died."
Next: Troubleshooting >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
