[
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
http://www.jumpstarttv.com/Media.aspx?vid=40