Import the IIS logs into database

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  November 16, 2010 at 2:14 am

  #143547

  Hi friends,

  I am new to ssis and i struggling to import the IIS logs into database.I want this mechanisam through ssis package.If anybody knows the idea then please send ASAP.

  thanks in adavance

  

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  November 16, 2010 at 3:17 am

  #1251191

  you can do this with SSIS, setup a flat file connection to the logs and then send the data to a database.

  However an easier and possibly better way would be to use the free log parser tool from MS that can query IIS logs and save them to a database.

  http://www.microsoft.com/downloads/en/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  November 16, 2010 at 3:43 am

  #1251197

  Thank you!