I have never used DTS, but I believe it is the tool for my current project.

We have regional databases supporting sales reps across the country. For the purposes of management reporting we want to store the data in a central database, containing all regions.

The aim is to have incremental updates sent from each regional database to the central database.

Reading through the online books under sql server 2000 there is a mass of information.
I have tried to play with the DTS new package panel to create connections, one for the source and one for the destination database.
I am struggling to achieve this.

Has anyone out there done anything similar? I'd appreciate some guidance.
Our transaction records will involve inserts and updates , no deletions.

I am wondering how incremental transactions can be processed.
I am assuming that sql can be written to filter rows based on date & time criteria.

I am also assuming that scripts have to be written on the destination side to instruct the process to update or insert the transactions transfered across from the source.

At the moment it seems vague and somewhat complicated for me, an example of sql or script would help me understand the processing involved.