HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Integration Services Catalogs - Version Description

Submitted by: @import:stackexchange-dba··
0
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

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.