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.