Post reply

Checkpoint in ssis2008

  • January 10, 2014 at 12:19 am

    #284260

    Hi,

    let i configured checkpoint for dataflow task.

    This task having oledb source and oledb destination.

    if there are 200K rows to be transfered and it got failed after 100K.

    Then what will happen if i ll start again.

    Destnation table will be 200K or 300K records.

    Thanks

    Rohit

  • January 10, 2014 at 12:49 am

    #1679050

    Checkpoints do not work inside data flows.

    If the data flow fails, the insert transaction on the database should fail and all inserted rows should be rolled back. This behaviour depends on batch sizes and commit sizes, so you better test it out for your scenario.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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