June 24, 2016 at 1:26 am
Hello,
I most often read all the relative topics before I ask for help but I really could not find a solution to the problem I am facing.
The problem is that I create a simple ssis package that exports data from an OLE DB source to excel destination.
Most of the data types are converted to DT_STR in SSIS succesfully. One field is the price field with money datatype in SQL server and in SSIS I use DT_CY for the comversion. When I simply copy and paste the results from the sql server grid (with dot ) the results are with comma in excel but when I run the package the excel decimal seperator is with dot, for example I would like to have 1234,56 instead of 1234.56.
I hope I was clear on my problem and someone could help,
Thank you!
June 27, 2016 at 8:29 am
What collation are you using?
Viewing 2 posts - 1 through 2 (of 2 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