I have a sql script which is invoked via a batch file which I want to parameterize based on the environment.
Essentially the batch file calls sqlcmd.exe
I want to run this script after my azure package has deployed.
The trouble is that if I add the batch file to my nuget package it seems that the Work folder gets deleted immediately after the Azure step has deployed, so that I have no way of running the batch file.
Can you advise on how to achieve this?