All Columns on any Teradata table with decimals are truncated when they are returned to SQL server using DTS.
But...... When I use MS Access against a view of a teradata table using the same ODBC connection the decimals are not truncated. (I used a view because MS Access was only letting me link to a view via the ODBC connection)
I tried DTS using the same view but I got the same results (decimals were truncated).
Since I could look at the data in MS Access using the same ODBC connection, I would think that excludes Teradata & the ODBC connection from being the culprit. So I inclined to believe it's related to DTS when accessing Teradata. I do not have the decimal truncation problem using DTS and DB2.
The TD table was originally created using Multiload the column in question was defined
.FIELD INVC_AVG_CS_PRC_L * DECIMAL(7,3) ;
Looking at the table via WINDDI shows the table defintion as
type decimal, length 4, format -----.999 & nullable