Configure SSIS Catalog task is failing in deployment pipeline with file not found error

Question

Hi

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:

1. Deploy the SSIS project using the SSIS Deploy task type
2. Configure the project catalog using the SSIS Catalog Configuration task type

The first step works without issue.

The second task fails when it attempts to update the first system parameter contained in the inline JSON file. It recognises that the parameter already exists so needs to overwrite it

The configure SSIS Catalog task is failing in a deployment pipeline 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 dll in the 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

Answer 1

We do not currently provide support for Azure DevOps on this site. Please use Stack Overflow for ADO questions as that is their official support channel as discussed here. They will better be able to help you over there.