The source parcel length does not match data that was defined.

Tools
Enthusiast

The source parcel length does not match data that was defined.

First I had exported delimited file:

Export Script:

.logon 127.0.0.1/tduser,tduser

.width 254

.export file = 'C:/TD/Export/Exp_delimited_file' LIMIT=1000

sel EMPNO||','||EMPNAME||','||Salary||','||DOB||','||Job_Title||','||DEPTNO from dba_backup.emp_b;

.export reset

.logoff

Sample O/P:

((((((((((EMPNO||',')||EMPNAME)||',')||Salary)||',')||DOB)||

-------------------------------------------------------------------------------------------------

      45167,Tushar45067              ,  55066.00,08-05-2004,External,          7

      23002,Tushar22902              ,  32901.00,11-07-1997,Staff,          2



Now i am impoerting exported data through Import Script:

sessions 4;

.logon 127.0.0.1/tduser,tduser

drop table dba_backup.emp_de;

ct dba_backup.emp_de as dba_backup.emp with no data;

.import vartext ',' file = 'C:\TD\Export\Exp_delimited_file', SKIP = 2

.quiet on

.repeat *

using EMPNO(INTEGER),

      EMPNAME (CHAR(25)),

      Salary (DECIMAL(8,2)),

      DOB (DATE),

      Job_Title (VARCHAR(25)),

      DEPTNO (INTEGER)

INSERT INTO dba_backup.emp_de

(

      EMPNO,

      EMPNAME,

      Salary,

      DOB,

      Job_Title,

      DEPTNO

)

VALUES

(

     :EMPNO,

      :EMPNAME,

      :Salary,

      :DOB,

      :Job_Title,

      :DEPTNO

);

.quiet off

.quit

O/P:

 *** Starting Row 2 at Wed Aug 26 12:09:46 2015

 *** Failure 2673 The source parcel length does not match data that was defi

 ned.

                Statement# 1, Info =5 

Please guide.....

 *** Teradata Database Release is 13.00.00.12 

Thanks,

Tush