Post reply

Loading column having $ sign to SQL Server Destination

  • October 13, 2008 at 11:53 am

    #154806

    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.

  • October 13, 2008 at 2:46 pm

    #884330

    The dollar sign isn't stored in SQL Server. If you need to display the money columns with the symbol, it should be applied in the application.

    Greg

  • October 13, 2008 at 7:13 pm

    #884383

    Greg Charles (10/13/2008)

    The dollar sign isn't stored in SQL Server. If you need to display the money columns with the symbol, it should be applied in the application.

    Heh... true enough... but you might want to explain why it should be done that way. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply