'How to embed SQL script in Azure Data Factory Mapping Data Flows Expression Builder
After executing my mapping dataflow I would like to run a clean-up script using the Post SQL Script option of the Sink activity.
However I'm not having much success with the expression builder. This is what I've tried so far:
concat ( 'UPDATE [cfg].[Entity] SET SchemaVersion =' , toString(CachedEntities#lookup($EntityName).EntityID + 1) )
Solution 1:[1]
Thank you @user1309226 for updating the error cause and resolution in the comments. Posting it as an answer to help other community members.
This syntax worked: toString(CachedEntities#lookup($EntityName).SchemaVersion + 1)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | NiharikaMoola-MT |