Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Need to load IIS 5.0 Web Logs into SQL

Author  Topic 

JasonErdahl
Starting Member

3 Posts

Posted - 2001-05-21 : 18:54:35
Hello -

I'm sick of Webtrends and would like to load my IIS 5.0 Web Logs directly into SQL so I can analyze them. They are fairly large (1 Gig+). I just want to pull just the IP and URL information right now.

I've written VBScript to "push" the information into the database and it just takes too long. I'm thinking that a stored procedure could "pull" the information into the database much quicker.

Any tips?

Thanks,

Jason
   

- Advertisement -