catalog-create-folder-ssisdb-database.md

title	catalog.create_folder (SSISDB Database)
description	catalog.create_folder (SSISDB Database)
author	chugugrace
ms.author	chugu
ms.date	03/06/2017
ms.service	sql
ms.subservice	integration-services
ms.topic	reference

catalog.create_folder (SSISDB Database)

[!INCLUDEsqlserver-ssis]

[!INCLUDE SQL Server]

Creates a folder in the [!INCLUDEssISnoversion] catalog.

Syntax

catalog.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

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