Bulk Copy from one SQL Server to another SQL Server

Hi,

How can i use DTS for Bulk Copy from one SQL Server to another SQL Server?

Thank you,

Regards,

Palak Shah

Rather DTS use Replication..

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

http://msdn2.microsoft.com/en-us/library/aa237426(SQL.80).aspx

|||

Hi Palak,

There are various ways to do what you want. As suggested you could use Replication, however, to get the best answer for your scenario, what are the SQL versions of both the host and target server?

|||Actually I want to transfer Data from one DB to another provided that both are SQL Server 2000 with Target and Source at different Location.|||

If that is the case, you could use the sp_AddLinkedServer system stored procedure to register the remote server (providing you have the appropriate security principles in place) and execute your dts package under a transaction.

See here for an example of sp_AddLinkedServer;

http://www.codeproject.com/cs/database/Distributed_Servers.asp

Here for using DTS with transactions;

http://doc.ddart.net/mssql/sql2000/html/dtssql/dts_addf_tx_660j.htm

Also please note that Books online has extensive documentation on what you are trying to do, as does the following site(s);

http://msdn2.microsoft.com/en-gb/sql/aa336304.aspx

http://www.microsoft.com/technet/prodtechnol/sql/community/default.mspx