Post reply

DTS Rounding problems during data transformation...

  • February 21, 2006 at 5:25 am

    #68288

    I have a problem...

    Data transformation rounds or truncate decimals!

    I have an ODBC source in witch is a table with float numbers (ODBC Driver

    publish it as float).

    If I build a query form MS Access or from MS Excel with Query Analizer, I see all

    decimal places, but when I try to insert data using DTS, float numbers will

    be converted to its integer values.

    A preview "select * from table", with table ODBC table, gives integer value when

    runned from DTS to transform data from ODBC to MS-SQL Server table, and

    gives float values from Access or other tools.

    Where I can fix my problem?

    Thanks.

    Giorgio

  • February 22, 2006 at 4:50 am

    #622576

    Are you casting your value to an integer either implicitly or explicitly? Post your source table and destination table definitions and i'm sure someone here can figure it out for you.

    -Mike Gercevich

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply