Azure DevOps deploy pipeline SSIS Catalog Configuration task fails with a missing file error - Stack Overflow

admin2025-04-17  3

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
  3. 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.

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

转载请注明原文地址:http://www.anycun.com/QandA/1744904820a89274.html