2665 Invalid Date error in Teradata Parallel Transporter.

Tools & Utilities
Enthusiast

2665 Invalid Date error in Teradata Parallel Transporter.

Hi All,

I have a file with 9k records which gets successfully loaded by using Traditional Fastload Utility.

The same file when i try to load using Teradata Parallel Transporter LOAD Operator , all these records goes into ET table, with
errorcode 2665 - Invalid date -- For one of the DATE columns.

I've even tried giving FORMAT in the INSERT/SELECT part , but it still addresses that job completed successfully but all 9k records creeps into ET table.

The file is a TAB delimited file.

Please can you advise where i m going wrong ?

Regards,
Mtlrsk
1 REPLY
Teradata Employee

Re: 2665 Invalid Date error in Teradata Parallel Transporter.

Please supply the schema definition of your TPT script.
For TAB delimited files, the schema definition must be all VARCHAR.
-- SteveF