Article ID: 296093 - View products that this article applies to.
This article was previously published under Q296093
Microsoft Knowledge Base article
296085describes a utility that you can use to strip the header lines from an Internet Information Server/Services (IIS) log for bulk insert to Microsoft SQL Server. This article provides that utility as well as the source code.
(http://support.microsoft.com/kb/296085/EN-US/ )HOWTO: Analyzing Web Logs with SQL
The Prewebplog.exe utility takes the path and file name of an IIS log file, removes the lines that start with "#" (these are the header lines in Web logs) and outputs the file to STDOUT.
The following file is available for download from the Microsoft Download Center:
PrepWebLog.exeRelease Date: JUN-21-2001
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The PrepWebLog.exe file contains the following files:
(http://support.microsoft.com/kb/119591/EN-US/ )How to Obtain Microsoft Support Files from Online Services
To run the utility, use the following command:
Collapse this tableExpand this table
D:\>preplog.exe [name of web log]The output will go automatically go to STDOUT. Add a file name to direct to a specific output file:
D:\>preplog.exe [name of web log] > [name of output file]
For example, to send the output to a file called "C:\Out.log":
D:\>preplog.exe c:\blah.log > out.log