catalog.create_folder (SSISDB Database)

APPLIES TO: yesSQL Server yesSSIS Integration Runtime in Azure Data Factory yesAzure Synapse Analytics (SQL DW)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Creates a folder in the Integration Services catalog.


catalog.create_folder [@folder_name =] folder_name, [@folder_id =] folder_id OUTPUT  


[@folder_name =] folder_name
The name of the new folder. The folder_name is nvarchar(128).

[@folder_name =] folder_id
The unique identifier (ID) of the folder. The folder_id is bigint.

Return Code Value

The folder identifier is returned.

Result Sets



This stored procedure requires one of the following permissions:

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

Errors and Warnings

If a folder with the same name already exists, the stored procedure returns an error .