Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sreemace
Starting Member
9 Posts |
 Posted - 2005-02-07 : 13:10:12
|
| 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...Thanks & Regards,Sreejith G |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 14:11:20
|
| So why don't you use the BATCHSIZE option for BULK INSERT or the b switch for bcp.exe?Tara |
 |
|
|
|
|
|
Batch insert (OLAP)