Post reply

insert data in batches

  • October 3, 2011 at 3:07 am

    #99930

    Hi Guys,

    I need to insert data in batches from one table to another. The script needs to insert 500 000 records, when the import is done another process will run and the next 500 000 records will have to inserted again.

    Can you please assist with this as insert the data in batches will be easy to script but inserting the next 500 000 records and not inserting the same records from the source table will be a bit tricky.

    Regards

    IC

  • October 3, 2011 at 3:59 am

    #1389378

    You can do it quite easily with SSIS.

    Have you tried that?

    -- Gianluca Sartori

  • October 3, 2011 at 4:02 am

    #1389380

    it depends on your source data, if you have an icremental key or datestamp then it should fairly simple.

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

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