Home Forums Data Warehousing Integration Services What happens if new records are inserted in a source table during a package execution? RE: What happens if new records are inserted in a source table during a package execution?

  • May 13, 2013 at 3:30 pm

    #1614798

    opc.three (5/13/2013)

    If you are using either Snapshot Isolation or READ COMMITTED SNAPSHOT ISOLATION (RCSI) mode that could account for the behavior you are seeing. My comments are related to the default iso level, READ COMMITTED, with RCSI OFF.

    Ah - we are indeed running with READ_COMMITTED_SNAPSHOT set to ON.

    Jason Wolfkill