Introduction
—————
I’m in need of two scripts that parse and mine raw data logs into a Microsoft SQL Server.
Scenario
———–
A marketing company has a web service where their customers which are Canadian Universities access on a daily bases. The traffic generated at the web service produces raw logs in the following tabbed delimited format:
Category Name (String)
Entry Point (String)
Traffic Date (Date)
Customer ID (String)
Traffic Count (Integer)
Interface (String…
