Roll back an SSIS package

• Eshika

  SSCrazy

  Points: 2046

  More actions

  October 5, 2010 at 12:17 am

  #224713

  Can I have some suggestions of how to Roll back an SSIS package.

  I am new to SSIS, have created a package which has a series of dataflow tasks and SQL task which truncates and transfers data between servers ...

  I need a check i e., before truncating it must check if the data @ source is available.If not available then it shouldn't truncate.

  Thank you in advance.

  Thanks,

  Swetha K

• Leo Suresh

  SSC Veteran

  Points: 221

  More actions

  October 5, 2010 at 1:03 am

  #1231479

  Hi,

  I am not sure under what circumstance you would want to roll back the DFT.

  I am assuming that the DFT needs to be rolled back, if any errors occur in subsequent conrol flow tasks in the package. Here is how to do this.

  Set the TransactionOption property of the package to "Required"

  Set the TransactionOption property of the dft to "Supported"

  If any error occurs in the control flow, then the dft will be rolled back.

  Regards,

  Suresh