Incrementally load data from Azure SQL Database to Azure Blob storage

Question

Hi,

I followed the incremental loading tutorial https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal and changed the "stored procedure" to a script, but it showed an "Incorrect syntax near '06'". Could you please help? Thanks

Following the the query:

UPDATE dbo.watermarktable
SET [WatermarkValue] = @{activity('LookupNewWaterMarkActivity').output.firstRow.NewWatermarkvalue}
WHERE [TableName] = @{activity('LookupOldWaterMarkActivity').output.firstRow.TableName}

Answer 1

Try using the single quotes ?

UPDATE dbo.watermarktable

SET [WatermarkValue] = '@{activity('LookupNewWaterMarkActivity').output.firstRow.NewWatermarkvalue}'

WHERE [TableName] = '@{activity('LookupOldWaterMarkActivity').output.firstRow.TableName}'

Answer 2

As I said before, while I added the single quotes, the script worked. Thanks again!