Sets the description of a folder in the Integration Services catalog.
set_folder_description [ @folder_name = ] folder_name , [ @folder_description = ] folder_description
[ @folder_name = ] folder_name
The name of the folder. The folder_name is nvarchar(128).
[ @folder_description = ] folder_description
The description of the folder. The folder_description is nvarchar(MAX).
Return Code Value
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 a message to confirm the setting of new folder description.