Roll back an SSIS package

  • Eshika

    SSCrazy

    Points: 2046

    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

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply