Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

How to insert log data to table using log parser?(SSIS Package)

I am using LogParser tool to insert data in db using MSUtil dll(SSIS Package)

I am using following code in script task component:

Looping through log files and using following :

SELECT TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time), 3600)),time,cs-method,cs-uri-stem,cs-uri-query,cs-username,c-ip,cs(User-Agent),cs(Referer),cs-host,sc-status,sc-substatus,sc-win32-status,time-taken 
FROM 'logfilename' 
TO 'table name'

But data is about 30-40 million in log files, so while inserting data in table i am getting error like

data is not inserted propery,but half data is inserted.

To catch the exception :logQuery.lastError == 0

How to insert this much of data into table?

Comments