• In SSIS you can encapsulate ETL process in transactions.

    A good article on transactions:

    [/url]

    Alex S