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...
Showing posts with label sourcerow. Show all posts
Showing posts with label sourcerow. Show all posts
Saturday, February 11, 2012
Subscribe to:
Posts (Atom)