Hi Folks, Data is truncating for measure column. for examaple: salary data in Source database as shown below : 100 200.345 300.654 But displaying as shown below after the dataload to destination: 100 200 300 Please help what to do. Thanks in advance.

What other components are in the data flow? Talk to me now on

It looks that your problem is in the source since you have scale = 0. Try this in management studio: select cast(200.345 as numeric(38,0)) -- returns 200 select cast(200.345 as numeric(38,3)) -- returns 200.345 Change the data type of that column to have a scale different from 0. David.