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 ?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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
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.
If you like futzing with the .ispac directly, in the @Project.manifest, the property is serialized under the
If you're referring to the description property on the package itself and not the folder, it can either be set in SSDT by entering a value in the appropriate property field, or, after deploying to the IS Catalog, by running an update query on the internal.packages table in the SSISDB.
Hope that helps.