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 |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-10-13 : 13:54:32
|
| Hello,I have a column name DollarAmount in the Excel Sheet. The format of the cells in this column have currency format with 3 decimal places. It means the data is somewhat this way: $15.900, $22.634, .......I have to load this data into the SQL Server table using SSIS.I tried to move into a table by giving datatype Currency and in the DataConversion Transformation also I converted the excel column into Currency Format. I had to use DataConversion as I have many other columns also.Now, my question is that I am able to get the data as 15.900, but the $ sign is missing. It is necessary for me to have a dollar sign also, but even after trying few datatypes in SQL Server table as well as Data Conversion Transformation in SSIS, I am not able to get the $ sign also passed from my excel spreadsheet.I guess it is not that tough, but I am not getting the right spot. Can anyone of you help me achieve this?Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-13 : 13:58:51
|
| you dont really need to store $ sign in table. storing the value as currency ensures you can use the formating functions in your front end to show the $ sign whenever you want to display them as $xxx.xxx |
 |
|
|
|
|
|
Loading column having $ sign to SQL Server...