| title | catalog.object_versions (SSISDB Database) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 03/04/2017 |
| ms.prod | sql |
| ms.prod_service | integration-services |
| ms.reviewer | |
| ms.technology | integration-services |
| ms.topic | language-reference |
| ms.assetid | 2fd8c020-1c77-4702-8e6b-efa6a348daab |
| author | chugugrace |
| ms.author | chugu |
[!INCLUDEssis-appliesto]
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]
Displays the versions of objects in the [!INCLUDEssISnoversion] 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.
Note
Row-level security is enforced; only rows that you have permission to view are displayed.