If you currently run SQL Server of MSDE on your desktop, you need to really be careful before migrating to Windows Vista. It has been announced that Windows Vista will only support SQL Server 2005 SP2 (yet to be released) and above. SQL Server 2000 and 7.0 will no longer be support. Is this going to slow support of Windows Vista. I can't help but to think it might for many enterprises that run MSDE on their desktop.
http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx
-- Brian
In this SSIS demonstration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.
Using Transactions in SSIS (watch the video)
Brian Kngiht