Hi,

We have a master database which I want to replicate/refresh just a few
columns of one table to another database table on regular basis throughout
the day to keep it updated.

Is there a DTS package/task made specifically to refresh data in this way or
do I have to write a procedure that will fetch the master data and perform
update/inserts on the dependent database table? Thanks. Dave.

You could use transactional replication, with vertical filtering of
articles.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


[quoted text, click to view]
Hi,

We have a master database which I want to replicate/refresh just a few
columns of one table to another database table on regular basis throughout
the day to keep it updated.

Is there a DTS package/task made specifically to refresh data in this way or
do I have to write a procedure that will fetch the master data and perform
update/inserts on the dependent database table? Thanks. Dave.