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
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