Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,608 questions
adding correct image.
getting source side error Can anyone suggest me solution for this
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 94%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
santosh
0
Reputation points
Failure happened on 'Source' side. 'Type=Microsoft.Data.SqlClient.SqlException,Message=An expression of non-boolean type specified in a context where a condition is expected, near 'updated'.,Source=Framework Microsoft SqlClient Data Provider,'
Azure Data Factory
2 answers
Sort by: Most helpful
-
santosh 0 Reputation points
2025-05-21T12:37:07.7833333+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
J N S S Kasyap 3,380 Reputation points Microsoft External Staff Moderator2025-05-22T09:15:01.23+00:00 @santosh
Just checking in to see if the below answer helped. If this answers your query, do clickAccept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know.
Sign in to comment -
-
J N S S Kasyap 3,380 Reputation points Microsoft External Staff Moderator
2025-05-21T13:36:43.4766667+00:00 Hi @santosh
An expression of non-boolean type specified in a context where a condition is expected, near 'updated'
This indicates a SQL syntax issue in your source query. This typically occurs when a non-boolean expression is used in a context that expects a boolean condition, such as a WHERE clause.
Review the source query or filter expression in your ADF copy activity, and ensure that the WHERE clause contains a valid boolean condition.
Please help me answer the below questions we can provide the best possible solution
- Can you share the exact source SQL query or filter expression you're using in the copy activity?
- Which part of the query is causing the error (e.g., the WHERE clause or a dynamic expression)?
- Have you recently made any changes to the source query or the schema that might have introduced this error?