I have built a deployment pipeline in Azure DevOps that deploys an SSIS project to a SQL Server 2019 instance using an Azure Pipelines agent running on the same server. The pipeline has two tasks:
The second task fails when it attempts to update the first system parameter contained in the inline JSON file.
The configure SSIS Catalog task is failing with the following error:
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies
Looking on the deployment server I can see the missing dll in the tasks folder structure under the Agent service C:..._tasks\SSISCatalog...\0.5.15\ps_modules\Microsoft.SqlServer.IntegrationServices.Commands.Cmdlets\
The product version of the batch parser dll on the server is 15.0.1000.16
The version of SQL server is 15.0.4236.7
Error logs on the task show:
##[error][Parameter: [ContainerName].[ParameterName]] Failed to update the parameter '[ContainerName].[ParameterName]': Operation 'Alter' on object 'ProjectInfo[@Name='ProjectName']' failed during execution..
Microsoft.SqlServer.IntegrationServices.Commands.ConfigurationException: Failed to import catalog configuration. ---> Microsoft.SqlServer.Management.Sdk.Sfc.SfcCRUDOperationFailedException: Operation 'Alter' on object 'ProjectInfo[@Name='ProjectName']' failed during execution. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. The specified module could not be found.
Any help to resolve this issue would be appreciated