Hi @Sanjeev Nayak ,
Thank you for posting query in Microsoft Q&A Platform.
The manual process you describe can probably be automated in an Azure DevOps pipeline, though there is no magic easy button. Instead of uploading the files as workspace packages, upload them to a storage account and reference them in the job definition, but the general idea is the same. Have custom scripts using either the Synapse Azure CLI commands or Az.Synapse PowerShell cmdlets to update the job definitions with the storage paths to the packages.
Kindly try and see if that helps. Please let us know how it goes. Thank you.