Post reply

datatype conversion error in dts

  • March 15, 2006 at 9:22 am

    #67397

    Hi

    I tried to export a text file to a sql server table.

    The data looks like that

    14,131004,3801.5853,-8735.9037,0,276,14/03/06,9,1.46

    14,131504,3801.6008,-8735.9158,0,318.1,14/03/06,9,1.46

    14,132005,3801.6006,-8735.9192,.1,282.4,14/03/06,8,1.56

    14,132505,3801.6124,-8735.9192,7.7,354.7,14/03/06,8,1.6

    16,133002,3803.1617,-8734.4734,18.2,49.7,14/03/06,5,2.64

    14,133005,3801.5771,-8735.9017,0,244.3,14/03/06,9,1.45

    10,133040,3801.5743,-8735.9223,0,312.3,14/03/06,7,1.79

    16,133502,3803.0718,-8735.394,35.1,275.2,14/03/06,3,2.19

    14,133505,3801.5731,-8735.9011,0,283,14/03/06,9,1.44

    17,134626,3803.05,-8734.6696,0,92.9,14/03/06,5,2.41

    16,134740,3801.5758,-8735.917,0,56.5,14/03/06,7,1.9

    17,135126,3802.9603,-8733.959,0,168.8,14/03/06,6,2.33

    16,135241,3803.0586,-8735.1044,28.3,89.4,14/03/06,5,3

    17,135627,3802.9623,-8733.9571,0,215,14/03/06,6,2.32

    16,135741,3802.9524,-8733.9174,0,147.3,14/03/06,6,2.68

     

    Error gives in column 4 datatype conversion from (source coloo4 db_string to destination column y db_numeric)

     

    I set destination colum of datatype numeric(38,4). But still it is not working. If I truncate the last digit from the decimal it ran successfully. I don't know what could be the problem.

     

    Please help on this

  • March 15, 2006 at 9:50 am

    #626831

    Hello,

    Decimal Data

    Decimal data consists of data that is stored to the least significant digit. Decimal data is stored using decimal or numeric data types in SQL Server. The number of bytes required to store a decimal or numeric value depends on the total number of digits for the data and the number of decimal digits to the right of the decimal point. For example, more bytes are required to store the value 19283.29383 than to store the value 1.1.

    so what is the datatype(size) you are using?


    Lucky

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

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