My client has an Azure SQL Database that has been generated by Entity Framework and I need to roll out some post deployment data to certain tables. I have created another repo with given EF would overwrite these changes if they were in the same repo –

• Post Deployment SQL File that calls a number of SQL Scripts
• SQL Scripts – Using Openjson and T-SQL Merge
• Json files with config data for the tables in question

Within my YAML, I have a SqlAzureDacpacDeployment@1 task that deploys a dacpac (previous task is a VSBuild) and I receive the following error:

Cannot bulk load because the file "D:a1sdacpacmy-file.json" could not be opened. Operating system error code 997(Overlapped I/O operation is in progress.).