Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2011-04-28 : 09:43:44
|
| 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 alsothe 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 dataPlease help in this |
|
|
ZZartin
Starting Member
30 Posts |
Posted - 2011-04-28 : 19:31:13
|
| Check the precision on your float field in the database, you're probably getting that error because the values you are importing have too many decimals places so you'd be losing precision if you imported them. You'll probably need to either increase the precision in the database or use a task in the dataflow to convert it to the same precision as your database field. |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2011-04-29 : 02:33:24
|
| In my database that columns data type is floati used the converter in data flow here i tried to convert folat and double floatin the both cases i am getting same error |
|
|
|
|
|
|
conversion problem