Share via

Update using Lookup Activity

Gayatri Krishnan 41 Reputation points
2022-01-04T05:00:02.203+00:00

Hi,

I am trying to perform update using Lookup activity using Azure MySQL connection and have a dummy select at the end of update but I am getting error as following
Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42000] [Microsoft][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT '1' AS DummyValue' at line 1,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [42000] [Microsoft][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT '1' AS DummyValue' at line 1,Source=MySQLODBC_sb64.dll,

Any help how to resolve this.

Thanks,

Gayatri

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Accepted answer
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    2022-01-04T06:07:31.283+00:00

    Hey,
    The lookup activity expects an output value, for which we need to a dummy select part.

    Can you please try executing the query which you have used in Lookup activity as is via SSMS in your MySQL database and test whether that query is getting executed as is.

    Based on my understanding, any query that would get executed normally in database, should be successful via lookup activity as well

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.