catalog.object_versions (SSISDB Database)


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

Displays the versions of objects in the Integration Services catalog. In this release, only versions of projects are supported in this view.

Column nameData typeDescription
object_version_lsnbigintThe unique identifier (ID) of the object version. This number is not guaranteed to be sequential.
object_idbigintThe unique ID of the object.
object_typesmallintThe type of object. A value of 20 will be displayed for projects.
object_namesysname(nvarchar(128))The name of the object.
descriptionnvarchar(1024)The description of the project.
created_bynvarchar(128)The name of the user who added the object to the catalog.
created_timedatetimeoffsetThe date and time at which the object was added to the catalog.
restored_bynvarchar(128)The name of the user who restored the object.
last_restored_timedatetimeoffsetThe date and time at which the object was last restored.

This view displays a row for each version of an object in the catalog.

To see rows in this view, you must have one of the following permissions:

  • READ permission on the object

  • Membership to the ssis_admin database role

  • Membership in the sysadmin server role.

System_CAPS_ICON_note.jpg Note

Row-level security is enforced; only rows that you have permission to view are displayed.

Community Additions