January 29, 2014 at 12:07 am
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
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
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
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
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
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
Thank you for your support Will try
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy