datatype conversion error in dts
-
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
-
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