none
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

Answers

  • 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.

    HTH

    Steef-Jan Wiggers

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

    http://soa-thoughts.blogspot.com/ | @SteefJan

    If this answers your question please mark it accordingly


    BizTalk
    Monday, December 19, 2011 5:50 PM
    Moderator