Hi experts I have source as Tab delimiter, in this file i am getting the data as string(data like 0.000000023001, ...etc), the data in the file is decimal some times the data will be like exponential also the actula data type is float in data base when i try to convert string data to float, i am getting this error The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data Please help in this

Why do you want to use floats in the database? It's an approximate-number data type for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type range can be represented exactly. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com