Transaction in SSIS (2012)


  • Hi,

    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.

    Am I doing something wrong here?

    • Edited by B3nt3n Thursday, July 18, 2013 3:50 PM
    Thursday, July 18, 2013 3:49 PM

All replies

  • Can you post a screenshot of the package?

    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    Thursday, July 18, 2013 7:56 PM