Fixed Query update DATETIME issue

[jurgen_de_jong]

I'm trying to convert a VARCHAR value to a DATETIME value in a table in a SQL database with the following Fixed Query Details:

update SAPQNJDB.MPM_AFKOL

set GSUZS =  CONVERT(Datetime,'2012-03-28 11:10:00.000')

where AUFNR = '000001000648'

But I receive the error as below:

SQL error has occurred on query The SQL statement "update SAPQNJDB.MPM_AFKOL

set GSUZS =  CONVERT(Datetime,'2012-03-28 11:10:00.000')

where AUFNR = '000001000648'" contains the syntax error[s]: - 2:14 - Intermediate-SQL syntax error: CONVERT or TRANSLATE function not allowed

- 2:30 - SQL syntax error: the token "," was not expected here

- 2:30 - expecting "using", found ','

• SQL Version is 2008
• SAP MII Version 15.0 sp 0 patch 0
• Type: Querytemplate
• Datasource Modes: Command

A normal select query on the same tables just works fine.

[jurgen_de_jong · Accepted solution]

Issue is solved.

Changing the datasource from DataSource(SQL) to IDBC(SQL) did the trick