none
SQLBulkinsert Adapter to load flat file in two different tables RRS feed

  • Question

  • Here's my scenario I have a large flat file that I would like to try loading to SQL via the SQLBulkinsert Adapter. The challenge is I need to add a transaction ID and load the subscribers to one table and dependents to another table linked by this transaction ID. I have searched for some examples but have only found loading to a single table.  Any thoughts??

    Thank you!
    Wednesday, July 29, 2009 12:44 AM

Answers

  • You will probably need to do a staging table solution to put the data in and then use a procedure or job to move the data to the other tables, adding the transaction Id.

    Thanks,
    If this answers your question, please use the "Answer" button to say so | Ben Cline
    • Marked as answer by PARAGORIC Tuesday, August 4, 2009 5:59 PM
    Thursday, July 30, 2009 9:02 PM
    Moderator