Post reply

Is it possible to Pause the SSIS package Execution on error?

  • March 17, 2008 at 3:01 am

    #128308

    Hi,

    I need to build a package which will run every overnight if any error occurs I want package to be paused and next day if i want to continue the execution it should start from the paused point or it should resume. is it possible to do??

  • March 17, 2008 at 7:49 am

    #790343

    I think you would like to implement checkpoints in your package.

    check for "checkpoints" in control flow properties window.

    For more

  • March 17, 2008 at 9:35 am

    #790420

    I agree with Jay. While checkpoints don't actually "pause" the package execution, they allow you to restart it from the point where an error occured without having to rerun the entire package.

    Greg

  • March 17, 2008 at 10:34 pm

    #790671

    Got it! Thanks a lot

Viewing 4 posts - 1 through 3 (of 3 total)

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