Scenario :
I have two SQL servers (both PROD), located in same city but hosted on
different machines.
I need to transfer data from one Server.Database to another Server.Database
- size of data ranges upto 2 mm.
Size of both the tables are huge & slowing insertion a bit.

I need to select data from source db - with some basic filtering (date) - &
insert into destination db.

Tools to be used -
Any compoenet of DTS (SQL Server 2000).

Issue: Slowness -
#Approach 1) I tried using BCP in (file being saved on my local) - this was
slowest - since data had to travel across networks.
#Approach 2) Data pump. Little better but still slow.

Possible restrictions -
I may not be able to create file on database server - since they are PROD
server. This may make Bulk data import - Server based BCP not bad options.
Though, i can try to create such file on some third db server (say DEV) - but
again that will be a different machine.

Can someone suggest me some better (faster) option for this?
May be some wizard or something else?
I have tried some fine tuning steps for DTS (cache & stuff) but didnt help
much in this case.

Thanks in Advance