Koen Verbeeck shows off the Script activity in Azure Data Factory:
Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused with the script task/component of SSIS, which allows you to execute .NET script (C# for most people, or VB if you’re Ben Weissman). No, this task executes SQL, so it’s more akin to the Execute SQL Task of SSIS.
Click through to see how it works while I lament the fact that SSIS never supported the best .NET language.