I'm loading tables to teradata from sql server 2005 with tpt (odbc-load operator), when I execute the tpt's all the records loaded into an error table (_ET) , the errorcode i got is : 2673 it means "The source parcel length does not match data that was defined." , it is happening for most of the tpt's scripts, so I think I´m doing somethig wrong
Don´t understand why I´m getting this error, for me all is correct !
this is my structure table in sql: TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH NUMERIC_PRECISION NUMERIC_PRECISION_RADIX dbo AA PCC 2 YES nvarchar 255 dbo AA IATA 1 YES float 53 10 dbo AA GDS 3 YES nvarchar 255
Your schema does not look like it is matching the data being returned from SQLServer. The schema from the source table has to VARCHARs and a FLOAT. But your script schema has 3 CHARs. Your script schema should match the format of the data as it is being returned by the driver. If you want, just for an experiment, try to CAST the IATA column to CHAR(30) and see if that helps.
Also, if "nvarchar" in SQLServer syntax corresponds to a Teradata VARCHAR, then your script schema should have VARCHAR for the "nvarchar" columns from the source table.