Decimal fields are imported from csv files to the database tables without the decimal part.
(12.547 --> 12.000).
The data imported via SSIS.
This is the definition ion the Flat File Connection Manager:
Solution:
Declare the fields in the Flat File Connection Manager as Numeric, with the correct precision and scale:
Why decimal declaration is not fit to decimal fields? Ask Microsoft :)
