andersg98 (8/1/2012)

---

I saw a proof a concept where change data capture was turned on in the replicated database and then SSIS could use the change data functions to find the specific keys that had been add/changed then pulled those from the replicated data and loaded into DW. This achieved near real time DW reporting without impact to the primary database at all.