patternsqlMinor
Integration Services Catalogs - Version Description
Viewed 0 times
versiondescriptionservicesintegrationcatalogs
Problem
In Integration Services Catalogs I can see what versions of a package/project are available and if necessary revert to an older version. On this dialog I see a field "description" however I found no way yet to put a description into this field. How can it be edited/filled ?
Solution
I assume you're describing this window
What the answer wasn't
Folder's have descriptions, you can set them via the catalog.set_folder_description stored procedure. In my example, my folder is called SSISHackAndSlash and my project is SSISHackAndSlash2012.
I called the above method and looked at the properties of the folder and they match.
I then tried to use the same call but using the Project name but no dice
Msg 27104, Level 16, State 1, Procedure set_folder_description, Line
73 Cannot find the folder 'SSISHackAndSlash2012' because it does not
exist or you do not have sufficient permissions.
That's the only public proc in the list of all the SSISDB Stored Procedures that mentions description.
The actual deploy proc, catalog.deploy_project doesn't have a parameter for description.
What the answer is
Since the answer wasn't in the public catalog and it lead me to believe it either wasn't an exposed property or it's something in the actual project itself. Occam's razor wins.
Win
If you like futzing with the .ispac directly, in the @Project.manifest, the property is serialized under the `
What the answer wasn't
Folder's have descriptions, you can set them via the catalog.set_folder_description stored procedure. In my example, my folder is called SSISHackAndSlash and my project is SSISHackAndSlash2012.
I called the above method and looked at the properties of the folder and they match.
I then tried to use the same call but using the Project name but no dice
EXECUTE catalog.set_folder_description
@project_name
, @folder_description = 'called from set_folder_description'Msg 27104, Level 16, State 1, Procedure set_folder_description, Line
73 Cannot find the folder 'SSISHackAndSlash2012' because it does not
exist or you do not have sufficient permissions.
That's the only public proc in the list of all the SSISDB Stored Procedures that mentions description.
The actual deploy proc, catalog.deploy_project doesn't have a parameter for description.
What the answer is
Since the answer wasn't in the public catalog and it lead me to believe it either wasn't an exposed property or it's something in the actual project itself. Occam's razor wins.
Win
If you like futzing with the .ispac directly, in the @Project.manifest, the property is serialized under the `
node as `Code Snippets
EXECUTE catalog.set_folder_description
@project_name
, @folder_description = 'called from set_folder_description'Context
StackExchange Database Administrators Q#34425, answer score: 2
Revisions (0)
No revisions yet.