SQL Server Performance Forum – Threads Archive
DTS Newbie – using DTS on Client PCHi again, If I understand correctly, initiating a DTS request from
Ent Mgr on my PC is not the same as initiating the DTS request when
logged in to a Sql Server. In the former situation, data must be copied from source server to the PC and then to the target destination server. In the latter, the data is copied directly from the source server to the target server. In the former, is there any way to speed up the transfer ? Thanks, Paul
DTS is a client-side application.
It is better to use DTS packages carefully and they must be installed on Server and save as file to deploy on others if needed. In the first case it will have problems in transforming data between 2 servers and from the server side it will be faster as compared. http://vyaskn.tripod.com/sql_server_dts_best_practices.htm fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Hi Satya, Yes, you are absolutely right ! I ran the DTS package on the destination Sql Server and the time ran 50% faster.
Estimated 20 hrs using Client vs. 9 hr on dest Sql Server. The other key issue is Fetch Buffer and Batch Commit values in DTS. Regards, Paul