ODBC Update query is giving error - SSIS

I have configured the Execute SQL task in SSIS with ODBC ThoughtSpot connection. I'm getting this error when I'm writing the query manually. This is the similar error I'm getting while performing delete operation.

Query

update "schemaname"."tablename" set "field_varchar" = 'notupdated' where 1=1;

Error Observed:

[Execute SQL Task] Error: Executing the query "update "schemaname"."tablename" ..." failed with the following error: "[ThoughtSpot][SQLEngine] (31480) syntax error near 'update "schemaname"."tablename" set "field_varchar" = 'updated' where 1=1;<<< ??? >>>'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


 

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 8 mths agoLast active
  • 4Replies
  • 185Views
  • 6 Following