Post reply

Bulk loads versus Bulk inserts (Oracle DB as data source)

  • August 3, 2018 at 3:39 am

    #407368

    Dear all,

    I was speaking with one of my developers about the possibility to use bulk inserts to move the infromation from Oracle DB into our SQL Server stagging area.

    The reply was this:

    "We are using Bulk Loads (notbulk inserts command) on most stages now. We still of course need to monitortest and propose improvements if needed."

    What is the difference between Bulk Loads and Bulk inserts and which ones are faster?

    Can I use Bulk inserts inside the SPs that are triggered by our SSIS process? or do I need to use this bulk loads?

    We have an oracle data source which expose views to us. Then we have our stag are that is feeded by SSIS packages that call SPs. this all done inside SQL Server as we are a Microsoft BI plat form with src2stg; stg2DM and DM2cube alll using microsoft technology.

    Thank you

  • August 4, 2018 at 12:07 pm

    #2000280

    Which one is faster??? Test it and find out because the answer is and always will be, "It Depends". 😉

    --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)

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

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