Andy Leonard shows how to create an Integration Services ExecuteSQL task using Biml:
You do not yet have an SSIS package. You have the Biml template of a package. I can hear you thinking, “So how does this become an SSIS package, Andy?” I’m glad you asked!
We now need to execute the BimlScript and then build the output.
Follow along with the images.