October 28, 2004 at 5:17 pm
I receive the error in the title when trying to import a fixed width text file (roughly 1200 characters per row).
I was able to import 3 of the files already, but on the last couple of files I have received this error. Currently I am running SQL 2000 on a Windows 2k3 server with 2 GB of RAM on it. Each of the files I am importing have roughly 4Mil records. I have also imported much the same type of file with upwards of 14Mil records and not ran into this problem.
Anyone got some ideas of what it might be that I can at least try to go look at? Google so far hasn't given me enough information to find the answer.
October 28, 2004 at 7:35 pm
October 29, 2004 at 9:28 am
The raw table has 274 columns that I'm importing from, and all 274 columns in my database are char fields of varying lengths just so I can avoid such a scenarios as you are speaking of. I'd rather convert the data once I have it all imported.
Also, there is approximately 200 GB of free space on the drive which is housing both the log and data file and they are both free to grow as large as necessary.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply