Thanks Leo while exporting i have exported in YYYY-MM-DD format from the table to Flat file in ANSI Date format and while importing also im using the same format YYYY-MM-DD.There are two date columns in that table, calendar_date and the run_date.im getting error only in the run_date but not in the calendar_date.the error is Invalid Date and the error code is 2665.
The following is the description of the error message you got.
2665 Invalid date. Explanation: This error occurs when date arithmetic is attempted on an invalid date. Generated By: AMP Steps. For Whom: End User. Notes: Dates are stored as integers in the form YYMMDD, where YY is a calendar year beginning with 1900. Values such as 861332 are invalid as dates and may not be used where the value is to be used as a DATE data type. This error can also occur when character strings are being converted to DATE and the character data is in the wrong format or conversion results in an invalid value. Remedy: Correct and resubmit the request.
You hit this error due to 2 reasons
(1) Invalid integer date in Import data.
(2) Error during conversion of character strings to DATE.
The error you are facing could be due to Conversion of datatype.