As part of my DTS package, I am using a Multiphase Data Pump. When an insert
or transform error occurs I am recording the error details in the database
via ADO.

Now, the error processors for some reason do not give me access to errors: I
tried using the VBScript Err object, but this isn't available for some
reason. I have a COM component which runs GetExecutionErrorInfo for the
package but again, this isn't available.

I am sure that this code was working before and cannot for the life of me
work out what might have caused the change. I tried setting the task to
execute on the DTS main thread.. still no success..

Does anyone have any ideas what is happening?

OK, after worrying this to death, I think that I have an answer. I think
this is a bug in DTS:

If you run a function/sub from within On_InsertError phase, the underlying
error details are not stored in DTS. you only get the "The number of failing
rows exceeds the maximum specified."
If you remove/comment out the function, you get the full error details
appended eg "The number of failing rows exceeds the maximum specified.
(Microsoft OLE DB Provider for SQL Server (80040e2f): The statement has been
terminated.) (Microsoft OLE DB Provider for SQL Server (80040e2f): Violation
of PRIMARY KEY constraint"


"Dirc" <dirc.khan-evans (AT) eqos (DOT) com> wrote