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 |
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
 Posted - 2001-06-05 : 11:46:21
|
| I am trying to load a very big text file into a single table with just varchar fields (to avoid conversion errors on the load). I can do this using DTS with no problems - all rows/records loaded.When I use BULK INSERT I get an error some way through the load....Error 4832: Unexpected end-of-file (EOF) characterMy BULK INSERT is shown below:BULK INSERT tablename FROM 'd:\testing\temp\temp.txt' WITH (FIELDTERMINATOR=',',ROWTERMINATOR='\n',FIRSTROW=0,LASTROW=0,ROWS_PER_BATCH=10000,MAXERRORS=9999)Is this maybe something to do with the physical size of the input file (about 2.5Gb)?Help!Also - is there any way of using the equivalent of a trigger on a bulk insert?(I am using SQL Server 2K) |
|
|
|
|
|
Bulk Insert vs DTS