Skip to content

Latest commit

 

History

History
49 lines (33 loc) · 1.29 KB

catalog-create-folder-ssisdb-database.md

File metadata and controls

49 lines (33 loc) · 1.29 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
catalog.create_folder (SSISDB Database)
catalog.create_folder (SSISDB Database)
chugugrace
chugu
03/06/2017
sql
integration-services
language-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 .