• I agree doing this in a loop or in chunks will give complete control. I too have experienced same problem.

    I have a question here : bcp will log or NOT, while inserting data to a table?