The following query cleared this up Daniel: D:\logparser>logparser "SELECT DISTINCT TO_LOWERCASE(EXTRACT_TOKEN(cs-uri-stem, 1, '/')) AS DirectoryName, * INTO E:\SummaryData\*\year_to_date.log FROM E:\w3logs\corp.weyer.com\WAWTCAIIS21\ex0610*.log WHERE DirectoryName NOT IN ('_vti_bin' ;'')" -i:IISW3C...

Yay! Good. Yep. Probably. Yep. Good luck! Sysinternals tools rock as much as LP does.

You were right on the money! Found both "WeyCoDir" and "weycodir" in my search. So if I've interpreted this correctly, I'm telling LogParser to wildcard to two separate (case sensitive) directories, which it is trying to do, while the operating system is resolving them to a single (case insensitive)...

Hrm. that certainly looks odd. I'd suggest trying out Sysinternal's FileMon utility filtering for *year_to_date.log* to see where and when LP is trying to write to the file. Given the error returned by LP, you should see a file system write lock error somewhere in there. The only thing I can think of...

Hi. I'm trying to multiplex multiple IIS log files from a single web domain into separate directories based on the web directory "root" located within the cs-uri-stem of each IIS log file entry. So far I've been able to create the separate directories for each directory "root" with no problem using a...

I thought of using (VB|J)Script as well, that might be the solution I end up going with. I'm trying to replace some custom C++ code that was written by a previous employee with something that is a bit more flexible for the future. Thanks for the input, Mark

It's a very interesting question but I'm sorry to report I don't have a good answer. :/ I can't think of any better way than the appending procedure you describe above. I take that back, I can think of one way. If you brought this solution into a VBScript or JScript solution and rather than using multiplexing...

I'm having a bit of trouble figuring out how to send an input record to more than one output file using the multiplex feature. I've got a text file that I'm processing with the TEXTLINE input format and I need to output records to more than one output file under certain conditions. For example, say the...

Yep, you're right, the SQL output format does not support multiplexing. That's a work item we have for the next major version. Sorry about that.

Is it possible to multiplex into different tables in a database? The following query works fine without multiplexing but it fails when I specify the table name with the asterisk. LogParser -i:EVT -createTable N -o:SQL -oConnString:"Driver={Microsoft Access Driver (*.mdb)};Dbq=.\database.mdb" "SELECT...