Writing to SQL fails via scheduler fails

Hi,

I have updated Advanced ETL Enterprise (64) to version 6.4.5.67
Running a package in debug works fine, but the scheduled execution fails with the following log.

Information    03/07/2025 10:52:04    Executing Transformation: Analisi Adozioni - Importa ELS_CustomerInventory su ETL
Information    03/07/2025 10:52:04        Starting Transformation...
Information    03/07/2025 10:52:04        Map Name: Analisi Adozioni - Importa ELS_CustomerInventory su ETL
Information    03/07/2025 10:52:04        Author: 
Information    03/07/2025 10:52:04        Version: 
Information    03/07/2025 10:52:04        Description: 
Information    03/07/2025 10:52:04        Preparing Writers...

Error    03/07/2025 10:52:04         42000 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '0'.
 

I assume that  you are using agent for execution

Most likely the problem you are having is related to user regional settings.

Eg you have two users

USER1 user used to design transformations and everything is working fine
USER2 is used to run transformations using agent and it is failing

Check user USER2 regional settings and make sure that they are the same as USER1.

Also are you using windows authentification for sql server connections ot you are using sql server users?

It might also related to sql server user defalt language

everything was working fine before the update and neither the SQL settings nor the users used have changed

We are trying to reproduce it in the office.

Please provide a screenshot of sql server connection dialogue

The package uses a transformation that reads a view from an SQL database and writes a table to another SQL database on the same server SQL 2019.
Both the ETL server and the SQL server are Windows 2022 standard