Difference in number format (comma and dot) on SSMS and SSIS I have a numeric(5,2) field on my SQL Server database. When I run the query, the number on that field appears with . (dot) separator. However, when I preview the query on SSIS, it appears with comma(,) separator. I am trying to show the number format with dot(.) on SSIS as well. How can I do that?
Thank you.
The issue here is that the Locale settings of the file connection in SSIS are different to the language settings in SQL Server.

In SSIS, go to the Properties window for your File Connection (Right-click->Properties). There should be a setting for LocaleID that will need to be set to match SQL Server (or to English).

Further information can be found in the following Stack Overflow post