Post reply

Transaction Control inside a DataFlow Task

  • April 23, 2010 at 6:15 am

    #386772

    Hail guys!

    I got a question about the Transaction Control in a Data Flow Task. Let's say that I have a Data Flow Task, and inside it I got a OledbSource, a Multicast and below it I have 3 OleDBDestinations.

    My need is to rollback only a register if it fails in one of the inserts, and the Data Flow to keep executing till the end.

    In case SSIS does not do it right out-of-the-box, is there a workaround to get things done?

    Thanks in advance!

  • April 23, 2010 at 9:58 am

    #1156994

    Have you considered setting max error count at some value other than one, perhaps add one per destination maybe.. Don't know if this will do what you are asking because I have never done it this way.

    I have to admit that this methodology makes me a little uncomfortable. It would be a lot safer to have it all fail and for you to fix it. Or better yet for you to build the process so that the likelyhood of it dying is greatly reduced.

    CEWII

  • April 27, 2010 at 2:40 am

    #1158032

    Thanks Elliot!

    I staged the data first, like you recommended.

    Thanks again!

  • April 27, 2010 at 2:25 pm

    #1158512

    You are welcome.

    CEWII

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

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