Using Transactions

If you wish to use commit/rollback transactions, select the Check Box “Use Transactions” on the Destination tab for OLE DB or ODBC connections. When enabled, all database operations to the destination will be performed, but not committed until the end of the Job. If an error occurs while processing the Job, all actions are rolled back.