SSIS package while running from SQL server agent Job, converts dot to comma in exported csv file.

Question

Hello all,

I have created a SSIS package that is extracting data from a database table to a CSV file.

When I run the package directly from SSIS Catalog it is working OK ( the decimal point is a point) but when I call the same package from a SQL Server Agent job of an instance located on the same server as SSIS, the output CSV file will have the comma instead of a decimal point that is messing the columns of csv.

Output from CSV:

Col1 Col2
11.5 15.2

Output from SQL Job:

Col1 Col2
11, 5 15, 2

Any help would be appreciated.

Answer 1

Hi @Deeba Parveen ,

SSIS is using a Flat File connection in the Flat File Destination.
Flat File destination has a LocaleID property that controls commas, dots, etc.

It seems that the SQL Server Agent job is using a modified connection via a different SSIS Environment.
So, you need to check that setting.

Answer 2

This is due to the locale setting on the SQL Server.

Please see:
https://social.msdn.microsoft.com/Forums/en-US/4d592048-33d9-480d-915d-e6de8e788def/force-decimal-separator-while-exporting-to-flat-file?forum=sqlintegrationservices

Answer 3

Hi @Deeba Parveen ,

The issue seems to be 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).

You may refer how-to-import-a-flat-file-without-changing-regional-settings-on-the-deployment-s

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.