SSIS Transactional Processing Options ... and the one that is my favorite - Hands On Easy Demo!
In this video I discuss seven ways to emulate transactional processing in an SSIS package. I then explain why I like one of them the most, and then show an example of using that method. Techniques include MSDTC, Snapshot Backup, Data Recovery Model - Full, Change Data Capture, and Transact SQL.