Post reply

Placing Checkpoints in data flow

  • August 27, 2008 at 1:05 am

    #863524

    No.

    That is why you execute queries in a transaction. Either Everything or Nothing. ACID.

    You _could_ do it via a script component but that would be very very slow.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 28, 2008 at 8:37 am

    #864449

    I cannot execute in transaction..

    its like loading and cathing error and coming out..

    I want to know how can i make sure tht if I start the same job again it will start from that point data flow

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • August 28, 2008 at 8:43 am

    #864461

    You cannot.

    Checkpoint files restart from a certain task. A dataflow is a task. You cannot restart from point withing the dataflow. Think how much custom logic that would require.

    If you really have to, you would have to build your own logic with conditional splits etc. Far to much work.

    Use a transaction over the task.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

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

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