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 |
|
Roman168
Starting Member
2 Posts |
 Posted - 2011-05-23 : 04:23:40
|
| Hey, i have issue thats driving me crazy. I have data in txt field"card_id";"number";"type";"issued"1005;928.5;"classic";931107 00:00:00104;58.8;"classic";940119 00:00:00747;491.5;"classic";940205 00:00:0070;43.9;"classic";940208 00:00:00577;368.7;"classic";940215 00:00:00377;242.9;"classic";940303 00:00:00721;468.0;"junior";940405 00:00:00437;276.2;"classic";940601 00:00:00i am pasting it so you can see that there is no white characters spaces etc.I do import using flat file source in SSIS and field "number" according to sql ssis cannot be converted to float or double. I tried derived column but there go with exception An error occurred while attempting to perform a type cast or i used Data Convertion but "The value could not be converted because of a potential loss of data. "(with any types of real numbers) i try anything i could find but now i giving up. i would appreciate your help. |
|
|
Roman168
Starting Member
2 Posts |
Posted - 2011-05-23 : 05:34:18
|
| Ok. for the descendans i found the soultion . Switch dots to comas |
 |
|
|
|
|
|
[convert data] I cant convert string to float