Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: Maximum INput that a BCP utility can take

    Can any one help me out form this... I just want to know the maximum input a bcp utility can take..... its a direct insert from one table to another but contains millions of data


  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    How many millions? The last largest bulk insert I've done (it's running daily, and no, I don't do TRUNCATE TABLE before it ) varied between 800 million and 1.6 billion. The width was around 4K characters, and the job execution varied between 3 and 5 hours. I suspect you'll run into OS limitations before you start having problems with bulk load.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts