IIS access log to SQL normalization
I haven't done it myself, but there are several articles on using SSIS to transform the data. The principle will apply to other ETL tools I guess


http://www.databasejournal.com/features/mssql/article.php/3650326/Using-SQL-for-IIS-Logs-Part-2.htm
MS Log Parser
How-To: SQL query IIS Logs with Log Parser


and


maybe for reporting only?