Home Forums Data Warehousing Integration Services How to know if data is committed after an insert RE: How to know if data is committed after an insert

  • November 29, 2015 at 12:13 pm

    #1842752

    dplaut 49149 (11/28/2015)

    It is obvious from what I'm seeing that the next step does not have the data in the table just loaded.

    What is it that you're seeing to make you think so? And, are you sure you're not just seeing some problem with a "screen refresh" somewhere along the line? Or, is you job step calling another job, which WOULD run asynchronously?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)