Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-03-16 : 03:22:08
|
| HiWhen trying to import a large amount of data from a flatfile (.csv) I get the following error message:-Attempting to grow LOB beyond maximum allowed size of 2,147,483,647 bytes.The size of the file I am attempting to import is 7310069 KBI am using the 'Bulk Insert' statement at present to import inside a SP, this then allows me to automate the import, is there a way I can import the file in smaller chunks, or is there a workaround for this? |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2009-03-16 : 03:34:40
|
| Update:Found this article which may help me out:-http://msdn.microsoft.com/en-us/library/ms188267(SQL.90).aspx |
 |
|
|
|
|
|
Importing large amount of data - Problem!