Archives of the TeradataForum

Message Posted: Tue, 04 Nov 2003 @ 20:30:23 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I am having a problem losing my decimal precision after importing data from Teradata using DTS.

I am using an ODBC connection to Teradata specifying the input as a query. "Select * from flm.VEL_CR_HDR_HIST"

The column on Teradata is defined as type decimal, length 4, format -----.999 & nullable

The column is defined by DTS import on SQL server as numeric with precision 7 scale 3.

The input data viewed thru queryman, WINDDI and even MS ACCESS using ODBC shows 19.07. However, when I look at the DTS test results for the column it shows 19.000. When I execute the import and view the table it shows 19.000

I have tried changing the DTS "select" to use a cast statement as decimal(7,3) but it didn't make any difference.

Can anyone help me? Is there some parameter in SQL server or Teradata that is causing this truncation of the decimal precision?

Thanks

Shirley McArdle
Fleming Estate

	<Prev	Next>		<<First	<Prev	Next>	Last>>