oracle adapter bulk insert (bts 2006) RRS feed

  • Question

  • im using the oracle adapter in order to insert data in to the DB 

    i created a loop and insert each time one  node

    is their any way to create bulk insert,

    or any other way in order to speed up the process


    Monday, December 19, 2011 5:44 PM


  • Hi,

    You can opt for SSIS to bulk insert data, which gives you a gain in performance and lesser overhead compared to BizTalk. SSIS is relative simple and offers through connection managers accessibility to for instance Oracle, see my post.


    Steef-Jan Wiggers

    Ordina ICT B.V. | MVP & MCTS BizTalk Server 2010 | @SteefJan

    If this answers your question please mark it accordingly

    Monday, December 19, 2011 5:50 PM