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
Post a Comment