none
How to Retry a Data Flow RRS feed

  • Question

  • I need advice on how to retry a Data Flow if it errors.  There is one problematic data flow within a .dtsx w many other data flows.  The DF is a relatively OLE DB Source to OLE DB target task, except that it is long-running and sometimes gets timed out at the source.  Not sure how to do it with the event handler.  Any advice appreciated.

    Friday, April 4, 2008 3:43 PM

Answers

  • You could investigate checkpoints in SSIS to see if they will work for your purpose. Be aware that there are some limitations with using them.

     

    I usually set up my packages so that they can be re-run easily, by performing some checks to see if they errored on the previous execution and cleaning up if they did.

     

    Friday, April 4, 2008 7:31 PM
    Moderator

All replies

  • You cannot restart a data flow.

     

    Friday, April 4, 2008 3:54 PM
    Moderator
  • You could investigate checkpoints in SSIS to see if they will work for your purpose. Be aware that there are some limitations with using them.

     

    I usually set up my packages so that they can be re-run easily, by performing some checks to see if they errored on the previous execution and cleaning up if they did.

     

    Friday, April 4, 2008 7:31 PM
    Moderator