TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

catalog.create_folder (SSISDB Database)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Creates a folder in the Integration Services 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.

The folder identifier is returned.

None

This stored procedure requires one of the following permissions:

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

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

Community Additions

ADD
Show:
© 2016 Microsoft