catalog.create_folder (SSISDB Database)

  • Article

Creates a folder in the Integration Services catalog.

Syntax

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

Arguments

  • [ @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

None

Permissions

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

The stored procedure returns an error if a folder with the same name already exists.