I was looking around the other day on Google! and elsewhere for info on SSIS transactions and MSDTC setup, but didn’t find much; actually what I found were a lot of questions around their use. Check out my screencast as I geek with them, and try to make heads or tails out of their use. Expand the embedded video and check it out!
Hopefully this will help someone down the road when setting up and configuring SSIS packages to use transactions.
Lee Everest, M.S.
www.texastoo.com
------------------------
This dude chose not to watch the vid
Code: http://texastoo.com/images/ssistransactions.zip
86560c0b-ed2f-4654-948a-be39165d36cf|2|5.0