Replication could be problematic as SQL will replicate the DELETEs as well as the INSERTs.
Also, do you need to capture UPDATE activity or just INSERTs?
Finally, are you on Enterprise or Standard Edition?
CDC could work well for this if you are on Ent Ed (unfortunately, CDC is not available on Std Ed).
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".