I use DTS for some years and want to improve error handling. I want to use the multiphase data pump function to retrieve the row-id in case of error. Now strange thing is when I don't use multiphase I get the full erorr stack like (I log error to the server, see table sysdtssteplog):
"Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): ActiveX Scripting Transform 'DTSTransformation__1' encountered an invalid data value for 'USER_DEF_NUM_1' destination column.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0"
When I activiate multiphase data pump, I only get the last error which is not very infornative:
"Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified.
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
"
I tried every return status from the book in the OnTransformFailure/OnInsertFalure function (like DTSTransformStat_SkipRowInfo) but nothing gives the full error.
Any help or tip is appreciated!
Gerard.
"Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): ActiveX Scripting Transform 'DTSTransformation__1' encountered an invalid data value for 'USER_DEF_NUM_1' destination column.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0"
When I activiate multiphase data pump, I only get the last error which is not very infornative:
"Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified.
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
"
I tried every return status from the book in the OnTransformFailure/OnInsertFalure function (like DTSTransformStat_SkipRowInfo) but nothing gives the full error.
Any help or tip is appreciated!
Gerard.