February 28, 2001 06:28 PM

Working with IIS 5.0 Logs

Rating: (0)
Ken Spencer
Windows IT Pro
InstantDoc ID #19880
Move Web site log data to a SQL Server database for easier analysis
Microsoft Internet Information Services (IIS) 5.0 logs Web-server events by default. You can choose to turn logging off or ignore log data, but more likely, you want to collect and analyze the data for insight into how users use your Web site. Like Internet Information Server (IIS) 4.0, IIS 5.0 gives you a choice of log-file formats and lets you log to a file or directly to a database. My preferred meth...

ARTICLE TOOLS

Want to use this article? Click here for options!

You must be a paid Professional Member to access this entire article.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Monthly or Annual

Professional Membership

VIP Membership

Compare Member Benefits

Add a Comment

Importing a text file with DTS is trivial. The key information is the piece regarding grabbing the proper file since it is a dynamic file name. That piece is completely ignored.

karoo 2/28/2004 11:44:41 AM

In your article, you talk about the steps involved in importing IIS logs into a SQL Server table. My question is about the task that is supposed to copy the log file and strip out the header information. (I understand how to setupt the DTS package to import the data from that file.)

So here goes: Is the file copy and header-stripping task supposed to be part of the DTS package, or are you suggesting that I write a program to handle that (in something like VB or a simple .BAT file), and schedule it with the AT command at the OS level on the server?

I don't have much experience with DTS packages, so I'm a little foggy on tasks that you can and cannot perform through DTS.

Thanks,


Conrad Jalali 11/30/2001 6:50:42 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
Free Power Tools Brochure
Get Mark Minasi's 17-page guide today!



      

advertisement

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

White Papers

Your remote offices contain valuable electronic data – are they adequately protected? Learn how proven technologies can reliably and cost-effectively back up a branch office from a central location, in real time, to disk or tape, and even utilize existing backup solutions.

Downloads

PacketTrap IT is a comprehensive and affordable network management and application monitoring solution that solves problems associated with bandwidth, network and application performance, and connectivity. Gain insight into your network - try PacketTrapIT free for 21 days!

Web Seminars

IT administrators have to solve a myriad of problems. This web seminar outlines the ten most common systems management pains - including managing highly distributed systems and dealing with data theft/loss – and the best practices to address each.

eLearning Series

We bring the experts direct to you to share their real-world perspective and expertise. During each event, three sessions stream in real time, so you can learn, ask questions, and get solutions.
Upcoming event: Getting the Most with Exchange 2010 with Paul Robichaux

Subscribe to Windows IT Pro!

DevProConnections ITTV Left-Brain SharePointPro Connections SQL Server Magazine SuperSite for Windows Windows IT Pro

© Penton Media, Inc.

Home About Us Advertise Customer Service Privacy Statement Subscribe/Renew Terms Of Use

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.