將iis日志文件導入數據庫
1#Software: Microsoft Internet Information Services 5.1
2#Version: 1.0
3#Date: 2006-04-22 22:56:28
4#Fields: date time c-ip cs-username cs-method cs-uri-stem sc-status sc-bytes cs-version cs(User-Agent) cs(Referer)
52006-04-22 22:56:28 127.0.0.1 - GET /Cepsmis/ 302 287 HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+Maxthon;+.NET+CLR+1.1.4322) -
1BULK INSERT pubs..ex FROM ‘C:\WINDOWS\system32\Logfiles\W3SVC1\exyymmdd.log‘
2WITH (
3 FIRSTROW = 2,
4 DATAFILETYPE = ‘char‘,
5 FIELDTERMINATOR = ‘ ‘,
6 ROWTERMINATOR = ‘\n‘
7)
每天動(dòng)態(tài)導入數據
Declare @filename varchar(6)
DECLARE @logfile varchar(200)
DECLARE @sql varchar(300)
select @filename = convert(varchar(6), GETUTCDATE()-1,12)
set @logfile = ‘C:\WINDOWS\system32\Logfiles\W3SVC1\ex‘ + @filename + ‘.log‘
set @sql = ‘BULK INSERT pubs..ex0604221 FROM "‘ + @logfile + ‘" WITH (CHECK_CONSTRAINTS, FIRSTROW = 2,DATAFILETYPE = ‘‘char‘‘, FIELDTERMINATOR = ‘‘ ‘‘,ROWTERMINATOR = ‘‘\n‘‘)‘
--print @sql
exec(@sql)
本站僅提供存儲服務(wù)，所有內容均由用戶(hù)發(fā)布，如發(fā)現有害或侵權內容，請
點(diǎn)擊舉報。
