Is there any way to get the native error information about an insert error
via the SSIS ole db destination component? I'm finding the dts error codes
are too generic to be helpful. For instance via SSIS the error code
represents a generic error like "The data value violates integrity
constraints". The same insert via SQL workbench will provide a error
description that includes the name of the constraint being violated such as
"Msg 2627, Level 14, State 1, Line 2 Violation of PRIMARY KEY constraint
'XPK_lab_finding'. Cannot insert duplicate key in object 'dbo.Lab_Finding'."


Perhaps I need an enhance ole db destination component that exposes the
oledbError.nativeError property. Has anyone seen articles discussing how to
do this?