Need best approach for insert into multiple SQL tables RRS feed

  • Question

  • Hi

    I have a requirement to extract elements from big xml and insert these elements into more than 40 tables. We have storedprocedures defined, few of them are using output parameter of one SP as a input of other SP. In a day we get around 100K xmls, so planning to use multiple threads to extract elements and insert into DB.

    Can someone please suggest, what is the best approach to implement this project.



    Monday, May 27, 2013 6:53 AM