Has anyone out there used a piece of software called Log Parser before? I am trying to import out IIS log files into a sql server database, so that we can report on them using sql server report writer. Has anyone managed to do this before? If yes, could you please tell me how you managed to do it? Thanks Jason
Yes it is a good tool to manage such logs on day to day basis, I have referred tohttp://www.databasejournal.com/features/mssql/article.php/3515886 &http://www.logparser.com/Repository.htm previously. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
I used Microsoft SQL Server Report Pack for Internet Information Services (IIS) MS... But is was in RS 2000 and I don't know MS released for RS 2005... Microsoft SQL Server Report Pack for Internet Information Services (IIS) http://www.microsoft.com/downloads/...37-14c7-40e3-820b-e7ee653c68c0&DisplayLang=en MohammedU. Moderator SQL-Server-Performance.com
We are tring to use the web reporting tool from the Commerce Server and customize it base on our needs.
Have you checked any on Commerce Server related forums iN MSDN? Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
We decided today to develop a new solution that will fit better the business requirements in regards of web log analisys and reporting. Would have been nice to have something like Project REAL on BI, but for the moments there is none.
You might contact MS in this case or feedback onhttp://connect.microsoft.com for more information. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
