Forum Discussion

ujssd's avatar
ujssd
Copper Contributor
Nov 06, 2023

SSIS DevOps Tools error

I installed the https://marketplace.visualstudio.com/items?itemName=SSIS.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 https://learn.microsoft.com/en-us/sql/integration-services/devops/ssis-devops-overview?view=sql-server-2017#a-sample-inline-configuration-json 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

3 Replies

    • 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