Post reply

Remove $ from output excel???

  • January 29, 2014 at 12:07 am

    #303837

    Hi Experts,

    I would like to know how to remove the $ symbol from the output(destination) excel file.

    I have done Aggregate on the database table data and moved to Destination Excel file. I have seen $ symbol in the output file which i dont want to have.

    I have used data conversion transform and tried to change the data type to numeric and int, decimal.

    But still when i save and execute the $ remains in the output.

    IS there any ways to not to show $ symbol in the output table(excel file). Please let me know if anyone have the solution for this.

    Thank you in Advance,

    Best Regards,

    VijayVanamala

  • January 29, 2014 at 12:13 am

    #1684151

    Maybe the cells in the excel file are formatted as currency?

    Is the $ sign present in the original data?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 29, 2014 at 12:16 am

    #1684154

    Hi Koen,

    No, am new to SSIS. am using adventure works database and there is no $ symbol in the source file.

    I have used Data conversion and changed the data type from currency to other types like int, decimal,, numeric. But still the problem arise.

    I have changed manually in excel file to Number.

    Can we do it in SSIS ??? with any of the transformations??

  • January 29, 2014 at 12:34 am

    #1684159

    If the source data is numeric, just leave as it is. Don't use the data conversion component.

    The excel file, is it a blank file or is there already data in it?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 29, 2014 at 1:42 am

    #1684180

    The Source data type is money. and the excel file is empty(it is a new excel file used as destination).

    Can we change the data type in Database from money to decimal without affecting the data?? i don't think it is possible.

    Any solution or updates please post.

    Best Regards,

    VijayVanamala

  • January 29, 2014 at 1:46 am

    #1684182

    You can convert the data type in the source query itself.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 29, 2014 at 1:53 am

    #1684187

    Thank you for your support Will try

Viewing 7 posts - 1 through 6 (of 6 total)

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