Transferring a Database Using the SSIS Designer - Creating a New Package
(Page 4 of 7 )
It is easy to create a new package. Right click the SSIS Packages folder and click on New SSIS Package as shown. The folder on the machine C:Documents and SettingsJay My DocumentsVisual Studio 2005ProjectsTransferDBTransferDBPackage1.dtsx stores the package. Right click Package1.dtsx in Solution Explorer and change it to DBTrans.dtsx. Make sure you do not change the file type extension.
Adding a Transfer DB Task to the SSIS Designer
From the Control Flow Items in the Toolbox, click and draw the Transfer Data Base Task as shown in the next picture. If the execution leads to a success this turns blue; if it fails, it turns red. You may also double click this control in the toolbox so that it gets onto the Control Flow tabbed page of the SSIS Designer as shown. The small red circle with a cross implies it still needs some configuration.
Configuring the TransferDB task
Right click the Transfer Database Task to pop up a drop-down list as shown. From this list click on the shortcut ellipsis labeled Edit.
This brings up the Transfer Database Task Editor window. The navigational items on the left are General, Databases, and Expressions. While you are in the General related page, change the name of the task to TwoO5toExpress and for description you may add something suitable such as Copy TestBase to Express.
Click on Databases on the left to reveal the database-related items that need to be configured for this task (on the right) as shown. This consists of Connections, Destination Database and the Source Databases.
Next: Configuring Connections >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
