April 21, 2009 at 2:21 pm
We have SQL 2005 on two servers. On one server version is 9.0.3310 and the second one is 9.0.4035.
When importing files through BCP on 9.0.3310 everything works as desired, however the newer version of SQL returns truncation errors and fails.
Schema of both databases is exactly the same.
Has anyone experienced this issues before?
It fails on one of the columns which is defined a decimal(18,2). The value in the BCP file 363.145.
On the earlier version of SQL the import is successful and the number is rounded to 363.15
April 21, 2009 at 3:32 pm
I am not sure but it looks like the behavior of the newer version is correct. In the 9.0.3310 by rounding up the value, it changes the data which in many case would be wrong and undesired.
I will do an bcp upload to sp2 and sp3 version tomorrow to see if I get similar results.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply