Copy Table and data for each table

I Have to archive my transactional data in to the reporting database every day , where in I need to add new records and update existing records for every table in the database. How can I achieve this for every table in the database with out having to write a task or package for every table. The package has to be self maintaining such that when ever a new table or column is added to the transactional database it needs to be added automatically to the reporting database. Please advice.

[498 byte] By [Dheepa] at [2007-12-25]