I am pulling data from excel file and inserting the data into SQL DB. I have execute sql task with Begin Tran > seq container with my other exec sql + df tasks (within more seq containers) + some other tasks > commit/rollback. If if something
fails in one of the df that is inside 2nd or 3rd internal seq container, no previous exec sql/df changes are rolled back. Everything that went into (insert/update/delete) before that failed df is still in the database.
I have one excel source and one oledb source - with retainsameconnection property = True for OleDB source.