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 |
|
toby1
Starting Member
8 Posts |
 Posted - 2003-01-17 : 08:40:10
|
| Hi all. Got some answers but they are not correct so I ask you guys again. Would be really happy if somebody could help me. Im transferring a textfile to a table with an DTS package. The problem is that the field amount set to datatype money will not display the correct value. In the semicolon separated file the value looks like this: 27000,00 and when i look in the table after the transformation is don it will look like this: 2700000. How can I solve this. In my sql server 7 enviroment this works fine, but in sql server 2000 environment it does wrong.By the way I'm living in sweden so we use , instead of . |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-17 : 08:42:43
|
| Well, that's no different from what you posted originally, why didn't the solutions the others gave work?Please keep the original thread going, it will only confuse people to answer multiple posts:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23086 |
 |
|
|
|
|
|
Very strange values with Money type