2 databases in sql2000, and from one you want to move new/altered
information overnight into a datamart.
I'm well aware that DTS is for moving information, but I am not too
sure if facilities in it will handle recognising changed records.
I was wondering if there was a best practise out there for using DTS
for this type of thing?

I'm also aware that this sounds like replication, but I don't think
this is the solution in this scenario as the information can be altered
in the exchange.

Any help is appreciated !

Hello RedMan,

DTS can move changed/altered info just fine. The problem is not in moving
it rather in the identification. You will need to tell DTS how to identify
the relevant rows when it looks. Replication keeps track of changes in its
tables.

There is no internal way that DTS knows about changes. It can't because
you could realistically be importing from and exporting to a whole raft of
data sources and none of them might be a DBMS.

Allan