Hi

Can you try creating a DTS/SSIS package to transfer the data from your source server to destination? And schedule the package in an agent job to run every hour or so depending upon the amount of data that gets updated every hour ?

I have a scenario where we use a Package to refresh data from source just twice a day..

You might also have to consider a few points before you go ahead 1. No schedule conflicts affecting other jobs running on the server 2. Network bandwidth/resource utilization etc.. All these will depend upon the amount of data that is being transferred..