I've written a custom DTS task in .NET, and it seems to be working
fine. Now I'm trying to complete the logging and I'm able to write
details to the log and store them to SQL Server, no problem. However,
when I view the log, the 'status' of the detail records has a red 'X'
in it, and the Error Code reports "Failed" even though the overall
package status is successfull.

I've used both oLog.WriteTaskRecord(errNo, msg)--where errNo is 0 as
long as there is no current error) and oLog.WriteStringToLog(msg), and
the result is the same.

It's a small detail, but I'd rather not have the detail steps
reporting failed if they were indeed successfull.

Anyone know what I'm doing wrong?

Thanks in advance...

From memory you need to set the error number to 1. I know it doesn't make
any sense, I had exactly the same issue.

--
Darren Green
http://www.sqldts.com

"Rob" <robs (AT) asrcorp (DOT) com> wrote