Transferring a Database Using the SSIS Designer - Configuring Connections

(Page 5 of 7 )

Click on an empty area in the SourceConnection textbox, which gives an arrow handle for the drop-down as shown.

Click on the New connection... ellipsis to pop open the SMO Connection Manager Editor. In the dropdown of the server name click on HodentekMYSORIAN and Use SQL Server Authentication with a User name and Password. You may also test this connection. Click on the OK button.

Similar to the above procedure,  add the destination connection which is the SQL Express Server connection. When the connections are added, the Transfer Database Task Editor should have the following details configured:

Next: Configuring the Source Database >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Transferring a Database Using the SSIS Designer

· SSIS is well integrated with the Visual Studio 2005. In SQL 2000 server it was a...    · Good tutorial. However, what do you do when you get the error below because one or...   >>> Post your comment now!