Having thought about what you want to do, you may need a SQL job or DTS packages to extract data from TCD, and then import these results into another table.
Another thing you could perhaps try to do is to query directly on TCD, setting the DateTime variable as today. Bear in mind that TCD writes at least 2 records per call.