Hi,<br>I am inserting a plain text file into SQL Server using this:<br><br>BULK INSERT ImportData FROM 'C:\IMPORT\TEST.TXT' WITH(FIELDTERMINATOR = '¦',ROWTERMINATOR = '\n')<br><br>However the order of the text file must be kept when imported.<br>Sometimes it seems to get mixed up.<br>I can run this twice in SQL Analyser and get different results, but it generally works.<br><br>Any-one got any ideas about this???<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Intermittent BULK INSERT error
- Thread starter ColinM
- Start date
PavoneRich
MIS
If this is on a multi processor server. My guess is that the bulk insert is being processed in paralell. More than one thread working on the same task.<br><br>Try doing a bulk copy instead and see if that eliminates the problem.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
