none
analyzing log files w/ SSIS and SQL Server - any tutorials?

    Question

  • analyzing log files w/ SSIS and SQL Server - any tutorials? Thanks.....

    consider the data source as IIS log files.... can we read them using SSIS? and store it in SQL Server? And then do some "analysis"?

    Is this a possible scenario?

    what sort of problems do you see coming?

    Sunday, November 25, 2012 4:38 AM

Answers

  • You have to make sure your SSIS data source is expecting the appropriate type of log (ODBC) and that IIS is configured to use that log format. It should be pretty straight forward with IIS writing its logs to ODBC you can then just point an SSIS file connection at the log and pull it out as regular ETL job.

    http://msdn.microsoft.com/en-us/library/ms525410(v=vs.90).aspx


    If you're happy and you know it vote and mark.

    • Marked as answer by BigDataQ Monday, November 26, 2012 2:55 AM
    Sunday, November 25, 2012 1:06 PM
  • Look into the post http://www.sqlservercentral.com/Forums/Topic1021301-364-1.aspx#bm1021329 for more details. You can either use SSIS or Log parser(http://www.microsoft.com/en-us/download/details.aspx?id=24659) as mentioned in the thread.

    Venkataraman R Be Blessed by Divine

    • Marked as answer by BigDataQ Monday, November 26, 2012 2:55 AM
    Sunday, November 25, 2012 4:47 PM

All replies