Convert datatype in flat file source to oledb destination in mysql
In flat file source column datatype is float with length 8 , precision 53 and scale as NULL. While fetching into OLEDB destination the column value is getting truncated
Example source has values 11.10 its Been fetching as 11 in SQL
Can we convert the datatype of float to decimal with same length and precision?
Please help on this
Flat file source has values of float with length 8 prec 53 and scale as NULL ,if I’m using float in oledb destination in mysql decimal values are lost
Flat file source has values of float with length 8 prec 53 and scale as NULL ,if I’m using float in oledb destination in mysql decimal values are truncated
How could I use decimal datatype in this case for replacing of float?