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.

Hi, you're using OLE DB source component? What's the data type for that column (check in advanced editor of OLE DB source)? What's the data type in destination table? David.

Hi David, Thanks for the reply. I am using OLE DB. checked in advanced editor of OLE DB source: Source datatype: numeric [DT_NUMERIC] precision: 38 scale:0 Destination datatype: numeric [DT_NUMERIC] precision:14 scale:2