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...
Saturday, February 11, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment