Programming a process restart in SSIS - error code dependent

  • I am currently working in BIDS 2008. We are converting our whole system from a cognos scheme to a SSIS one. Now I have a logging process in place to collect any error information, however what I need is to be able to restart a process(loose term) if my connection errors out. This is mainly due to sometimes during my overnight run, my process trys to hit a datasource at just the wrong time and pops back a connection can not be established error. What I would like to do is catch that error(which I am doing) and restart only the process that failed. So for instance, lets say I have 3 dataflow tasks in 1 package. 2 run fine and 1 gets this connection error. I would like to somehow gather the bit of information I need to restart ONLY that dataflow task. Is this a possibility? I mean I am sure I can write a custom code script, but I wasn't sure where to start and how to reprocess only the failed dataflow task.

    Any insight or articles would be greatly appreciated.

    Thanks

    J

  • BUMP...

  • You can set a Precedence Contraint on a Control Flow Task that is based on the Failure of the Task. (I'm assuming that the task would be a Data Flow Task.)

    You might need to put only one Source and Destination in Each Data Flow Task so you can re-run it if it fails. You will probably need to put in some kind of counter and bail after a certain number of attempts so you don't get into an infinite loop if it fails every time.

    Steve

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

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