Update script is updating in azure sql table

Question

Hello Team,

The below mentioned script is updating properly in azure sql table(water mark table):

@{item().name}:

UPDATE STG.WATERMARK

SET TABLE_NAME='@{item().name}'

where Sequence=9 AND DESTINATION_TABLE_NAME='CoveredRecipients_US' AND '@{item().name}' LIKE '%CR-US%'

UPDATE STG.WATERMARK

SET TABLE_NAME='@{item().name}'

where Sequence=9 AND DESTINATION_TABLE_NAME='CoveredRecipients_Global' AND '@{item().name}' LIKE '%CR-Global%'

UPDATE STG.WATERMARK

SET TABLE_NAME='@{item().name}'

where Sequence=9 AND DESTINATION_TABLE_NAME='CoveredRecipients_France' AND '@{item().name}' LIKE '%CR-France%'

But the Result in Lookup activity is getting failed :

Please advise.

Answer 1

Lookup activity expects an output to be present whenever you execute any query. As your query is just update query, it is failing. Use script activity instead of lookup activity