I am sometimes getting the following error in MSSQL:
A DTS Package...
< ERRORERRORERRORERROR >
The number of failing rows exceeds the maximum specified.
TransformDateTimeString 'DTSTransformation_3' column pair 1 (source column 'Col003' (DBType_STR) destination column actual_date (DBType_WSTR))
Cannot parse input data string beginning at '1500'
< \ ERRORERRORERRORERROR >
Error is being throw with the source:
It has thrown this error for the last 3 Mondays but has worked in between.
What is the deal here? Thanks.
MORE DTS INFO:
DTS Package Description:
Transformation is of type: DateTimeString
Source yyyyMMddhhmmss (ex. 20050419100241)
Destination MMddyyyy (ex. 04192005)