Saturday, February 11, 2012

@@SourceRow: Logging Failed

I defined exception file in the DTS package options. I didn't use SQL7.0 format file.

A file with the following contents was created. But a source error file was not. Can someone have the similar experience?

DATA TRANSFORMATION SERVICES: Data Pump Exception Log

@.@.ErrorRow: 496702
Error during Transformation 'DTSTransformation__94' for Row number 496702. Errors encountered so far in this task: 8.

Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description:ActiveX Scripting Transform 'DTSTransformation__94' encountered an invalid data value for 'ANNUITY_BEGIN_DT' destination column.
Error Help File:sqldts80.hlp
Error Help Context ID:30632
@.@.SourceRow: Logging Failed

Error code: 80004005

@.@.ExecutionCompleted

Execution Completed: 3/24/2004 1:57:32 PM

************************************************** **************************************************Enable DTS package logging for further information.

Also try to delete the transform between those to columns and map them to the right columns...

No comments:

Post a Comment