Post reply

bcp only imports 223339 rows

  • November 22, 2002 at 11:57 am

    #79184

    I want to import a data file containing 317234 rows using bcp. However, bcp stopped after only importing 227739 rows. No error messages. Has anyone seen this before?

    Thanks

  • November 22, 2002 at 1:15 pm

    #442147

    How much disk space is available?

  • November 22, 2002 at 1:24 pm

    #442150

    3GB

  • November 22, 2002 at 1:32 pm

    #442153

    Is that disk space getting filled up when you are trying to insert the data into the database.Check the transaction log size.

  • November 22, 2002 at 2:49 pm

    #442163

    Thanks. I found out that the data was not "clean". Some rows contain more columns than the table being imported into. Apparently, bcp simply ignored these rows and didn't bother to generate any errors.

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

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