Error 6770 invalid timestamp when importing pipe delimited flatfile through AD0.Net or ODBC

Database

Error 6770 invalid timestamp when importing pipe delimited flatfile through AD0.Net or ODBC

Hello,

I'm trying to import a pipe delimited flatfile using the import functionality of the Teradata SQL Assistant through following SQL statement

insert into S0_SDB_COP.VVA_00213_S_ITM_CALLBACK (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

The 2 timestamps are mentioned in the flatfile as follow (17th and 18th column):

|30/03/2010 14:11:08|30/03/2010 14:11:08|

My table has 2 timestamp fields defined as:

, DT_START TIMESTAMP (0) FORMAT 'DD/MM/YYYYBHH:MI:SS'

, DT_END TIMESTAMP (0) FORMAT 'DD/MM/YYYYBHH:MI:SS'

I dont see anything wrong with the format in the flatfile. I also double checked the position of the columns in the flatfile to be sure they match the position of the column in the table.

I tried both ODBC and ADO.net connectivity in the SQL Teradata Assistant.

Still the same error....

Can anyone help?

Many thanks!

Vincent.