DTS (DATA TRANSFORMATION SERVICE)

DTS (Data Transformation Service): This service is used for sending or receiving the data between the databases. This name was changed as SSIS (SQL Server Integration Service) in SQL Server 2005.

Navigation:

Step1: Open SSMS (SQL Server Management Studio) and create the required received database (DESTINATION)

Step 2: In Object Explorer Expand Databasesà right click on SOURCEàTasksàExport Data

Step 3: Here we got Welcome Wizard, Click Next

Step 4: Select Data Source (Auto selected), Enter Server Name(Auto Generated)(KARTHIK),Use SQL Server Authentication and enter login(sa) and password(sa123),Select your required database From which you want to send the data from the database list box(SOURCE) and click Next

Step 5: Select Data Destination (Auto selected), Enter Server Name(KARTHIK),Use SQL Server Authentication and enter login(sa) and password(sa123),Select your required database To which you want to send the data from the database list box(DESTINATION) and click Next

Step 6: Click Next

Step 7:  Select your required tables to transfer and click Next

Step 8: Click Next

Step 9:Click Finish and observe the results

Open SSMS and enter into Destination Database and find the list of tables which transferred by using  SP_TABLES Stored Procedure.