csk 0 Newbie Poster

Hi Gurus,
I have little bit idea to Create a DTS Package to copy any 5 tables from Pubs to Northwind.
but how can i do the following ..?
Create a log table to store the package start time, end time, execution duration, records affected.
When any transaction inserts/updates/deletes any record in any of the 5 tables in Pubs the same has to be
updated in Northwind. you can also use stored procedures inside the DTS Package.
The DTS Package must run continuously. i.e. the package must identify the recently changed record in Pubs
and should copy the same to Northwind. The DTS Package should run continuously.
Please give your ideas.
Thanks
KK

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.