SSIS DevOps Tools – SSIS Catalog Configuration task is released in preview

This post has been republished via RSS; it originally appeared at: SQL Server Integration Services (SSIS) articles.

SSIS Catalog Configuration task is newly released in SSIS DevOps Tools extension.

 

SSIS Catalog Configuration task supports configuring folder/project/environment of SSIS Catalog with a configuration file in JSON format.

This task supports following scenarios:

  • Folder
    - Create folder.
    - Update folder description.
  • Project
    - Configure value of parameters, both literal value and referenced value are supported.
    - Add environment references.
  • Environment
    - Create environment.
    - Update environment description.
    - Create or update environment variable.

For more information, see document page.

 

ssis-catalog-configuation-task.png

 

 

 

One Reply to “SSIS DevOps Tools – SSIS Catalog Configuration task is released in preview”

  1. Hi,
    I tried using the Configure SSIS Catelog Task and also executed the inline JSON code successfully. The Code is below for your reference.
    {
    “folders”:
    [
    {
    “name”: “Devops”,
    “description”: “Devops Folder”,
    “references”: [
    {
    “environmentName”: “Dev”,
    “environmentFolder”: “Devops”
    },
    {
    “environmentName”: “Test”,
    “environmentFolder”: “.”
    }
    ]
    }
    ],
    “environments”:
    [
    {
    “name”: “Test”,
    “description”: “Test Environment”,
    “variables”:
    [
    {
    “name”: “ServerName”,
    “type”: “string”,
    “description”: “”,
    “value”: “ADMIN-PC\\MSSQL2019”,
    “sensitive”: false
    },
    {
    “name”: “DatabaseName”,
    “type”: “string”,
    “description”: “”,
    “value”: “Test”,
    “sensitive”: false
    }
    ]
    },
    {
    “name”: “Dev”,
    “description”: “Dev Environment”,
    “variables”:
    [
    {
    “name”: “ServerName”,
    “type”: “string”,
    “description”: “”,
    “value”: “ADMIN-PC\\MSSQL2022”,
    “sensitive”: false
    },
    {
    “name”: “DatabaseName”,
    “type”: “string”,
    “description”: “”,
    “value”: “SSIS_Evaluations”,
    “sensitive”: false
    }
    ]
    }
    ]
    }
    This executes perfectly but the Environments are not Created in the SSMS Target Server. Kindly help me out.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.