catalog.object_versions (SSISDB Database)

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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.

Remarks

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:

Note

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