Sounds like you're really looking for replication between the servers. Two
references on DTS, both from Wrox (hopefully you can find them) Professional
SQL Server 2000 DTS by Chaffin, Knight, and Robinson and SQL Server 2000
Programming by Robert Vieira. If I had to do this via DTS I would have an
action table which the triggers would write to (i.e. record 254 updated
12/1/03 5:00 AM, record 2 deleted 12/1/03 5:02 AM etc) and then would use
those tables to process the DTS Package. I really would suggest researching
about replication because at first description that's exactly what you're
proposing to do via DTS.

Brian Freeman
(770) 916-0595 ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

amir krugliak wrote:
> hi
>
> Is any one knows where can o fond a good material over the DTS
> Package.
>
> i have some problem regarding DTS Package.
> the task is to run 3 different quries in a specific time.
> the quries are: 1)find if new lines were added to one DB and if
> true move them to DB two.
> 2)find if new lines were deleted from DB one and if
> true delete them from DB two.
> 3)find if new lines were update in DB one and if
> true update them in DB two.
> the basic job regards DTS Package is to import/export data.
> AM I mistaken when i am trying to use DTS for that,and should i use
> regular job for it.
>
> thanks
MS Sql Server LazyDBA home page