Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaycatalog.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. |
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.