Deployment of synapse SQL objects is failing

Question

Team,

Whenevr I do deploy dacpac objects into Synapse SQL pool, I'm seeing below error, Any solution for same ?

2021-10-13T08:31:37.3844857Z ##[error]*** Could not deploy package.
2021-10-13T08:31:37.3965406Z ##[error]Error SQL72014: .Net SqlClient Data Provider: Msg 104309, Level 16, State 1, Line 1 There are no batches in the input script.
2021-10-13T08:31:37.4097937Z ##[error]Error SQL72045: Script execution error. The executed script:
2021-10-13T08:31:37.4314761Z ##[error]System.Management.Automation.RemoteException
2021-10-13T08:31:37.4467895Z ##[error]System.Management.Automation.RemoteException
2021-10-13T08:31:37.5579966Z ##[error]The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-

Answer 1

Hi @Koissan, Rinshad ,

Welcome to Microsoft Q&A forum and thanks for posting your query.

The error message - Error SQL72014: .Net SqlClient Data Provider: Msg 104309, Level 16, State 1, Line 1 There are no batches in the input script. , this error usually occurs when there are any empty sql scripts.

Note: Also please check if you have any SQL scripts which has the whole content commented as below (which is also treated as empty script):

I would recommend to verify if there any SQL scripts that are empty and if so, then please do remove them and try redeploying which should help overcome this issue.

Hope this info helps. Do let us know if you have further query.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators