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!