SSIS export to excel with comma decimal seperator

• odiseas24

  Old Hand

  Points: 328

  More actions

  June 24, 2016 at 1:26 am

  #317371

  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!

• JustMarie

  SSCertifiable

  Points: 7771

  More actions

  June 27, 2016 at 8:29 am

  #1887062

  What collation are you using?