Tool to import WebLogs into SQL Server

am 19.11.2007 22:07:19 von hassan

What can I use to import the Web logs into SQL Server on a daily basis ?

Thanks

Re: Tool to import WebLogs into SQL Server

am 19.11.2007 23:11:37 von Kristofer Gafvert

Hi,

BULK INSERT or bcp utility in SQL Server are two ways.

--
Regards,
Kristofer Gafvert
http://www.gafvert.info/iis/ - IIS Related Info

Hassan wrote:

>What can I use to import the Web logs into SQL Server on a daily basis ?
>
>Thanks

Re: Tool to import WebLogs into SQL Server

am 20.11.2007 01:29:49 von hassan

Whats the source format ? I know how to use Bulk Insert, but is there
anything special I need to do from the source format perspective.

How do you handle duplicate entries when you import into SQL ?

Do you have a sample script that I could use ?

Thanks
"Kristofer Gafvert" wrote in message
news:xn0fdw7ziw2m4nx01n@news.microsoft.com...
> Hi,
>
> BULK INSERT or bcp utility in SQL Server are two ways.
>
>
> --
> Regards,
> Kristofer Gafvert
> http://www.gafvert.info/iis/ - IIS Related Info
>
>
> Hassan wrote:
>
>>What can I use to import the Web logs into SQL Server on a daily basis ?
>>
>>Thanks

Re: Tool to import WebLogs into SQL Server

am 20.11.2007 02:56:25 von Trevor Benedict R

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

here is a sample
http://www.databasejournal.com/features/mssql/article.php/35 15886

Regards,

Trevor Benedict
MCSD

"Hassan" wrote in message
news:%23ZDwxAvKIHA.5860@TK2MSFTNGP04.phx.gbl...
> What can I use to import the Web logs into SQL Server on a daily basis ?
>
> Thanks
>

Re: Tool to import WebLogs into SQL Server

am 20.11.2007 07:12:12 von Kristofer Gafvert

Hi,

Please see the following KB Article for instructions:

"How To Use SQL Server to Analyze Web Logs"
http://support.microsoft.com/kb/q296085/

It seems that i forgot that you need to remove the header lines, but there
are instructions in the KB Article, or use Log Parser.

--
Regards,
Kristofer Gafvert
http://www.gafvert.info/iis/ - IIS Related Info

Hassan wrote:

>Whats the source format ? I know how to use Bulk Insert, but is there
>anything special I need to do from the source format perspective.
>
>How do you handle duplicate entries when you import into SQL ?
>
>Do you have a sample script that I could use ?
>
>Thanks
>"Kristofer Gafvert" wrote in message
>news:xn0fdw7ziw2m4nx01n@news.microsoft.com...
>>Hi,
>>
>>BULK INSERT or bcp utility in SQL Server are two ways.
>>
>>
>>-- Regards,
>>Kristofer Gafvert
>>http://www.gafvert.info/iis/ - IIS Related Info
>>
>>
>>Hassan wrote:
>>
>>>What can I use to import the Web logs into SQL Server on a daily basis ?
>>>
>>>Thanks