I am working with SQL 2000 and have enabled the Multiphase Data Pump. I've
got a function handling the insertion failure phase because I want to ignore
primary key violations. I'm doing all of this in an ActiveX Script
transformaion. My problem is that I'd like to ignore primary key violations,
but log all other violations (null fields etc.) before going on to the next
row. I haven't been able to find any way to get error details within the
insertion failure phase so that I can distinguish one type of failure from
another.

Thanks for any help.

Zoe