Batch insert (OLAP)

  • Hi can any one help me with the skeleton script (sample one)of running Bulk insert in batches........ I need to do it in batches as the input data is huge.....

    The logic is I have to insert thru bcp in fact table...

    After that batch execution for 50,000 thousand record.... wise.... if any of the batch failes i need to identify and have to rerun from that point onwards...... this is OLAP thing...

  • Use OPENXML.  I have used it with 200,000 records, and

    no problem.

    Is extremely fast.

     

     

     

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

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