When loading 50MB file with
BULK INSERT #FlatStage
WITH (ROWTERMINATOR = '\n')
I get the beginning of the file shifted to the middle approximately. Otherwise the lines are in order (so the document starts in the middle, progresses to bottom, continues at the top).
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
View Complete Post