|
| |
How to transfer data using Data Transformation Services Wizard |
|
Expand the Server Group and select the server. |
| |
|
| |
|
|
Right-click, point to All Tasks and select Export Data. |
|
Data Transformation Services Wizard will be displayed and follow the steps. |
|
Select your data source in the Source box. |
|
In order to connect to SQL, give the username and password for authentication. |
|
In the Database box, select your database that is listed, similar to the screen displayed below. |
| |
|
|
Click Next |
|
In the Choose Database Destination, enter the details and a similar screen will be displayed. |
| |
|
| |
|
|
Click Next |
|
Specify the tables or queries to be transferred by choosing one of the option, as shown in the following screen. |
| |
 |
| |
|
|
In our example, Transfer objects and data between SQL Server 7.0 databases |
|
Click Next, and follow the steps as the Wizard prompts, and select options that are applicable to you. |
|
Click Finish, once all the given information is successfully specified, and your data has been transferred to the specified destination. |
