Forum Discussion

ujssd's avatar
ujssd
Copper Contributor
Nov 06, 2023

SSIS DevOps Tools error

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.

Azure DevOps
    • ujssd's avatar
      ujssd
      Copper Contributor
      Nov 14, 2023
      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.
      • mferla1420's avatar
        mferla1420
        Copper Contributor
        Jul 18, 2024
        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.

Resources