catalog.object_versions (SSISDB Database)

APPLIES TO: yesSQL Server yesSSIS Integration Runtime in Azure Data Factory yesAzure Synapse Analytics (SQL DW)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) 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 name Data type Description
object_version_lsn bigint The unique identifier (ID) of the object version. This number is not guaranteed to be sequential.
object_id bigint The unique ID of the object.
object_type smallint The type of object. A value of 20 will be displayed for projects.
object_name sysname(nvarchar(128)) The name of the object.
description nvarchar(1024) The description of the project.
created_by nvarchar(128) The name of the user who added the object to the catalog.
created_time datetimeoffset The date and time at which the object was added to the catalog.
restored_by nvarchar(128) The name of the user who restored the object.
last_restored_time datetimeoffset The 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.


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