Post reply

BCP File size limitation

  • December 4, 2001 at 8:43 pm

    #78361

    is there a maximun file size for BCP files

    I have a problem where I make a BCP file from an oracle table with 7.5 million rows

    when I bcp it into sql server the table only contains 6.8 million

    any ideas

  • December 4, 2001 at 10:34 pm

    #420758

    Not that I know of. I've loaded a couple mil, but never 7. I'll generate some data and try it tomorrow.

    Steve Jones

    steve@dkranch.net

  • December 5, 2001 at 4:17 pm

    #420807

    the problem was that I was FTPing the BCP file to the server and the drive which contains my FTPHOME did not have enough space for the file. So it just took as much as much space as was avialible and loaded the table with what data it contained in the file. no errors were caused which I thought would of happened.

  • December 6, 2001 at 7:23 pm

    #420858

    test

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

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