I have DTS package which is scheduled to run every day and imports the
data from Web server log files into Database which is on another
server. This job was running fine for last 3 years but suddenly it has
started failing. The DTS Web server log import task is failing and
gives the error mentioned below. This is a part of the trace which I
created using csdwdbgsrv.exe.

<DW-Parser> 1031-152625-809274 MultipleHits Parser stats: 100003 good
hits, 0 errors, log file size: 53218238, BuckStat:

<DW-Parser> MultipleHits Parser stats: 102925 good hits, 0 errors, log
file size: 53218238

<DW-Parser> All files have been processed

Caching Open Visits to the database - 1 buffers

Pipeline # 0, cached 145 open visits

Explicit flush invoked!

Err : HRESULT: -2147467259, Minor Code: 0, Source: , Description

Err : SQL Error: 0, Description: 22018

Err : InsertRow failed, hr = -2147467259

PrintTrace(), Bad argument, seq.id: 4282, mod: 1, file: 12, line: 624,
type: 6
Err : Error: in inserting row, cls: HttpStatus, index: 11, id: "

Err : Column Data: (HttpStatus, hr: 0x6) (IsSuccessCode, hr: 0xd)

Err : (170:4356)cls: HttpStatus, I: exception, signalling
termination of save batch due to error, hr: 0x-900038653 time:
1031-152633-546116.

Setting Completion Event for Import ID : 0, status code=0 (0x0)

Err : Storage detected errors on this connection with the SQL
Server. Data loss has occurred. hr: -900038653

Err : Storage detected errors on this connection with the SQL
Server. Data loss has occurred. hr: -900038653


time:1031-152633-625635 End Processing

I am sure this "PrintTrace(), Bad argument, seq.id: 4282, mod: 1,
file: 12, line: 624, type: 6" signifies something but not sure what it
means. Definately file 12 does not point to my log file as I was
trying to import only 4 log files when I ran this trace. Also there
are other jobs on the same server which are running succesfully and
importing the data from Log files using same connection which makes me
beleive that there is no problem with the connection. I have tried
omitting the log files to see if any one of the log file is causing a
problem but no success.

Any pointers or help on this will be really helpful.

Thanks