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
...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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment