Clever Geek Handbook

LogParser deletes log entries

I am importing IIS log files into a SQL database, but for some reason not every record ends up in the database. For example, if there are 1,000,000 records in the log file, then logparser says it has processed 1,000,000 records, but if I do SELECT COUNT (*) on the database, I don't have 1,000,000 rows of data. Has anyone seen this problem before?

+1


source to share


2 answers


Is the input truncated so that the row is discarded?



How you import (bcp, BUK INSERT, SSIS) decides if it's really a bulk load or line by line. Error handling options (ignore, break, max, etc.) determine what happens when truncating.

+1


source


Perhaps it counts the header lines (of which there are usually more than just what's at the top of the file) in the first count? Then are they discarded when importing to the DB? just a guess.



0


source






More articles:


All Articles