Question

SQl Executor

  • 14 August 2019
  • 3 replies
  • 9 views
L
Badge +1

Hi , I am getting this error message from my SQl Executor in FME. The Sql runs fine in MS studio Manager

(-2147467259) Unknown token received from SQL Server'

 

I am using a StringConcatenator for the script which passes the result to SQLExecutor

3 replies

david_r
Rank
Userlevel 4

Can you please give us some more information, e.g. some screenshots and the exact sql as it is sent by the SQLExecutor?

erik_jan
Rank
Userlevel 2
Badge +16

Is your SQL statement ending with a semicolon?

This can cause an error in the SQLExecutor.

L
Badge +1

No There was no semi colon but I did put in a new line in the StringConcatenator and the error has gone away.

Reply


Community Stats

28,717
Posts
109,495
Replies
36,560
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.