Hi, did you try to use data conversion feature to convert above values. Not sure but once i have used to convert string into integer. cpsingh

Hi, i need to convert 1.55 ----> 1.5E 20 3.10999------>1.10999E20 0.899----->8.99E 21 212 ------>2.12E 17 how do i achive this through ssis

Hi, Is there a logic to do the conversion? If not you can achieve this using a derived column Thanks,Sharath

If you are using this data for reporting purpose, suggest you format the data on reporting layer only. DO NOT FORMAT DATA ON ETL LAYERPlease vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

you can take derived column. it will convert to required format.indu

how can i achieve this through derived column thats i want

Hi, Not sure whats the data type of your column. But you can try something like this in derived column. SUBSTRING([Col_Name],1,3) + "E" + " 20"Sharath

Hi, did you try to use data conversion feature to convert above values. Not sure but once i have used to convert string into integer. cpsingh