DTS Transaction Problem

• Gogula G. Aryalingam

  SSCrazy

  Points: 2688

  More actions

  April 25, 2005 at 9:15 pm

  #163374

  Hi:

  MSDN states that The current package transaction is rolled back when the package finishes and the Commit on successful package completion check box is cleared for the package.

  But even though I keep the Commit on successful package completion check box cleared for the package, the package executes and the results are committed.

  Please Help.

  Gogula

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  April 27, 2005 at 6:39 am

  #555182

  You may have already looked into this but what about the checkbox for "Commit transaction on successful completion of this step" ?

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**