Removes data from the pool for all specific Name data from parameter

Question

Hello Team,

I have created a pipeline to remove a specific rows from the Sql Pool database. The output is coming perfectly. But in the Pipeline i am getting error.

The query is simple delete statement

The lookup activity I have used as "Query" in "Use query" option

delete FROM TableName
where FieldName1= '@{pipeline().parameters.FieldName1}'
and FieldName2='@{pipeline().parameters.FieldName2}'

Failure happened on 'Source' side. ErrorCode=SqlInvalidDbQueryString,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The specified SQL Query is not valid. It could be caused by that the query doesn't return any data. Invalid query: 'delete FROM Tablename where FieldName1= 'ABC' and FieldName2='003742' ',Source=Microsoft.DataTransfer.ClientLibrary,'

Thanks
RK

Answer 1

Yes after trying in different method in data flow it got worked.