[From Jumpstart TV
Database snapshots provide a handy way to provide data integrity for
Integration Services. In this presentation, Brian shows you how to create a
package that can "self-heal". In the event of any problem, the database will
automatically roll back to a pre-ETL snapshot.
The article continues at