SSIS DevOps Tools error

[ujssd]

I installed the SSIS DevOps Tools in my Azure DevOps instance so I can use Pipelines & Release to build SSIS Projects on my on-premises self-hosted agent (SHA) and deploy them to my on-premises SQL Server that has an SSISDB Catalog setup.

I am testing out the SSIS Catalog Configuration Task which is supposed to allow me to create folders (and projects and environments) in my SSIS Catalog before I attempt to deploy my SSIS Projects to it and I am running into errors I cannot decipher.

I am trying to get the sample JSON Microsoft provided working however I am running into this error:

##[error][Folder: devopsdemo] Failed to create the folder 'devopsdemo': Operation 'Create' on object 'CatalogFolder[@Name='devopsdemo']' failed during execution..

Does anyone have a working example they can share?

Note that I have setup a PowerShell Script Task in my Release that calls a Catalog Procedure to setup a folder in the SSIS Catalog and it was successful so I know the Catalog is online and that my service account has permissions to create folders.

[#2]

@ujssd 

See whether this can help:

In SSISDB New folder not able to create. – SQLServerCentral Forums

[#3]

Our "fix" after talking with support required Visual Studio 2022 Community Edition to be installed on the self-hosted agent. All is working as it should now.

[#4]

Weird fix, since I expect to get dependencies from the SSIS Deploy task itself, why do we have to install Visual Studio 2022 Community Edition.

I ran into the same issue, I use Windows Auth with Microsoft Managed Service Account the service has SSIS permission from Component Services and ssis_admin + db_owner in SQL.

As "workaround" I had to create the folder first, but it is not my preferred way and it should create the folder as mention in the documentation.