I have some ideas to process the following steps but will appreciate it if some experts share their thoughts with me:
(frequency is daily)
1) Information from IIS log file will be exported into a CSV (using IIS Logger in PS) file then a C# code will insert them all in a table (let's call it RawTable).
2) After having all the information for let's say for today, I need to break them into different tables. One table holds onto Client IPs and Server IPs, one table will have the browsers info and cookies information and etc
In general I'm having around 7 tables.
what technique do you suggest I go with? should I write few stored procedures or a 3rd party tool?''
*This process happens every midnight or early morning.