Hi,
I have a publisher and two subscibers of a merge-replication. When I delete,
update and insert data with a DTS-Package I need much more time as I do the
same thing with normal transact SQL commands.

DTS: need 2 hours
Transact-SQL: need 1 hour

When the merge-agents starts during the datatransfer. DTS needs 4,5 hours,
but Transact-SQL needs only 1 hour.

Why is the DTS perfomance dependent of the running merge-agents ?
Why is the DTS slower then Transact-SQL ?
How can I get a better performance of DTS ?

With replication I can not use fast load. Is there a way to use fast load
with mergereplication ?

When I use DTS with fast load and without replication, I need only 10
minutes for the same operation.

Best regards

Axel Lanser